@@ -0,0 +1 @@
+https://github.com/sqlc-dev/sqlc/issues/2731
@@ -0,0 +1,3 @@
+{
+  "contexts": ["managed-db"]
+}
@@ -0,0 +1,6 @@
+-- name: GetActionCodeByResource :one
+SELECT code, arr.item_object ->> 'code'  as resource_code
+FROM sys_actions,
+    jsonb_array_elements(resources) with ordinality arr(item_object, resource)
+    WHERE item_object->>'resource' = sqlc.arg('resource')
+    LIMIT 1;
@@ -0,0 +1,8 @@
+CREATE TABLE "sys_actions" (
+    "id" int8 NOT NULL,
+    "code" varchar(20) NOT NULL,
+    "menu" varchar(255) NOT NULL,
+    "title" varchar(20) NOT NULL,
+    "resources" jsonb,
+    PRIMARY KEY ("id")
+);
@@ -0,0 +1,10 @@
+version: "2"
+sql:
+  - engine: "postgresql"
+    schema: "schema.sql"
+    queries: "query.sql"
+    gen:
+      go:
+        package: "querytest"
+        out: "go"
+        sql_package: "pgx/v5"
Original file line number	Diff line number	Diff line change
`@@ -0,0 +1 @@`
	`1`	`+https://github.com/sqlc-dev/sqlc/issues/2731`
Original file line number	Diff line number	Diff line change
`@@ -0,0 +1,3 @@`
	`1`	`+{`
	`2`	`+ "contexts": ["managed-db"]`
	`3`	`+}`