gql2sql 2.0.17

GraphQL to SQL transpiler
Documentation
1
2
3
4
5
---
source: gql2sql/src/lib.rs
expression: statement.to_string()
---
SELECT json_build_object('getU7BBKiUwTgwiWMcgUYA4CById', (SELECT to_json((SELECT "root" FROM (SELECT "base"."BtaHL8fRtKFw8gDJULFYp", "join.WFqGH6dk8MpxfpHXh7awi_by_U7BBKiUwTgwiWMcgUYA4C" AS "WFqGH6dk8MpxfpHXh7awi_by_U7BBKiUwTgwiWMcgUYA4C", "base"."id") AS "root")) AS "root" FROM (SELECT * FROM "U7BBKiUwTgwiWMcgUYA4C" WHERE "id" = $1 LIMIT 1) AS "base" LEFT JOIN LATERAL (SELECT coalesce(json_agg(to_json((SELECT "root" FROM (SELECT "base.WFqGH6dk8MpxfpHXh7awi"."MHPB9NP84gr3eXBmBfbxh_id", "base.WFqGH6dk8MpxfpHXh7awi"."ynWfqMzGjjVQYzbKx4rMX", "base.WFqGH6dk8MpxfpHXh7awi"."QYtpTcmJCe6zfCHWwpNjR", "join.MHPB9NP84gr3eXBmBfbxh_id" AS "MHPB9NP84gr3eXBmBfbxh_id", "base.WFqGH6dk8MpxfpHXh7awi"."id") AS "root"))), '[]') AS "join.WFqGH6dk8MpxfpHXh7awi_by_U7BBKiUwTgwiWMcgUYA4C" FROM (SELECT * FROM "WFqGH6dk8MpxfpHXh7awi" WHERE "WFqGH6dk8MpxfpHXh7awi"."MHPB9NP84gr3eXBmBfbxh_id" = "base"."id") AS "base.WFqGH6dk8MpxfpHXh7awi" LEFT JOIN LATERAL (SELECT to_json((SELECT "root" FROM (SELECT "base.WFqGH6dk8MpxfpHXh7awi.U7BBKiUwTgwiWMcgUYA4C"."id", "base.WFqGH6dk8MpxfpHXh7awi.U7BBKiUwTgwiWMcgUYA4C"."id", 'U7BBKiUwTgwiWMcgUYA4C' AS "__typename") AS "root")) AS "join.MHPB9NP84gr3eXBmBfbxh_id" FROM (SELECT * FROM "U7BBKiUwTgwiWMcgUYA4C" WHERE "U7BBKiUwTgwiWMcgUYA4C"."id" = "base.WFqGH6dk8MpxfpHXh7awi"."MHPB9NP84gr3eXBmBfbxh_id" LIMIT 1) AS "base.WFqGH6dk8MpxfpHXh7awi.U7BBKiUwTgwiWMcgUYA4C") AS "join.MHPB9NP84gr3eXBmBfbxh_id.U7BBKiUwTgwiWMcgUYA4C" ON ('true')) AS "join.WFqGH6dk8MpxfpHXh7awi_by_U7BBKiUwTgwiWMcgUYA4C.WFqGH6dk8MpxfpHXh7awi" ON ('true'))) AS "data"