---
source: gql2sql/src/lib.rs
expression: statement.to_string()
---
SELECT json_build_object('getH33iDwNVqqMxAnVEgPaThById', (SELECT to_json((SELECT "root" FROM (SELECT "base"."d8GJJg9DjNehPAeJcpTjM", "join.Fjjm3XAhyDmbhzymrrkRT_Aggregate" AS "Fjjm3XAhyDmbhzymrrkRT_Aggregate", "base"."q6pJYTjmbprTNRdqG9Jrw", "base"."egeyQ33H3z4EqzcRVFchV", "base"."HYWfawTyxPNUf9a4DAH79", "join.H33iDwNVqqMxAnVEgPaTh_by_MdYg7jdht8ByhnKdfXBAb" AS "H33iDwNVqqMxAnVEgPaTh_by_MdYg7jdht8ByhnKdfXBAb", "base"."zFjEBPkLYmEAxLHrt3N4B", "base"."LJDX6neXAYeXt9aVWxTRk", "base"."FwpKpCegQH4EkzbjbNqVn", "base"."ayipLT8iKHNTdhmiVqmxq", "join.Mr3R877DKbWTNWRzmEjxE_Aggregate" AS "Mr3R877DKbWTNWRzmEjxE_Aggregate", "base"."r7xwAFrckDaVLwPzUAADB", "join.H33iDwNVqqMxAnVEgPaTh_by_User" AS "H33iDwNVqqMxAnVEgPaTh_by_User", "base"."id") AS "root")) AS "root" FROM (SELECT * FROM "H33iDwNVqqMxAnVEgPaTh" WHERE "id" = $1 LIMIT 1) AS "base" LEFT JOIN LATERAL (SELECT json_build_object('avg', json_build_object('XF4f6Qrhk86AX6dFWjYDt', AVG("XF4f6Qrhk86AX6dFWjYDt"))) AS "join.Fjjm3XAhyDmbhzymrrkRT_Aggregate" FROM (SELECT * FROM "Fjjm3XAhyDmbhzymrrkRT" WHERE "Fjjm3XAhyDmbhzymrrkRT"."id" = "base"."TbFeY8XVMaYnkQjDPWMkb_id") AS "base.Fjjm3XAhyDmbhzymrrkRT") AS "join.Fjjm3XAhyDmbhzymrrkRT_Aggregate.Fjjm3XAhyDmbhzymrrkRT" ON ('true') LEFT JOIN LATERAL (SELECT to_json((SELECT "root" FROM (SELECT "base.MdYg7jdht8ByhnKdfXBAb"."id", "base.MdYg7jdht8ByhnKdfXBAb"."H6hp6JGhzgPTYmLYwLk8P", "base.MdYg7jdht8ByhnKdfXBAb"."id") AS "root")) AS "join.H33iDwNVqqMxAnVEgPaTh_by_MdYg7jdht8ByhnKdfXBAb" FROM (SELECT * FROM "MdYg7jdht8ByhnKdfXBAb" WHERE "MdYg7jdht8ByhnKdfXBAb"."id" = "base"."MiyNcUJzKGJgQ9BERD8fr_id" LIMIT 1) AS "base.MdYg7jdht8ByhnKdfXBAb") AS "join.H33iDwNVqqMxAnVEgPaTh_by_MdYg7jdht8ByhnKdfXBAb.MdYg7jdht8ByhnKdfXBAb" ON ('true') LEFT JOIN LATERAL (SELECT json_build_object('count', COUNT(*)) AS "join.Mr3R877DKbWTNWRzmEjxE_Aggregate" FROM (SELECT * FROM "Mr3R877DKbWTNWRzmEjxE", "_H33iDwNVqqMxAnVEgPaThToMr3R877DKbWTNWRzmEjxE" WHERE "_H33iDwNVqqMxAnVEgPaThToMr3R877DKbWTNWRzmEjxE"."B" = "Mr3R877DKbWTNWRzmEjxE"."id" AND "_H33iDwNVqqMxAnVEgPaThToMr3R877DKbWTNWRzmEjxE"."A" = "base"."id") AS "base.Mr3R877DKbWTNWRzmEjxE") AS "join.Mr3R877DKbWTNWRzmEjxE_Aggregate.Mr3R877DKbWTNWRzmEjxE" ON ('true') LEFT JOIN LATERAL (SELECT to_json((SELECT "root" FROM (SELECT "base.User"."id", "base.User"."gnHezR9MdBFH9kCthN3aB", "base.User"."created_at", "base.User"."id") AS "root")) AS "join.H33iDwNVqqMxAnVEgPaTh_by_User" FROM (SELECT * FROM "User" WHERE "User"."id" = "base"."Gb8jAGqGDbYqfeqDDxKUF_id" LIMIT 1) AS "base.User") AS "join.H33iDwNVqqMxAnVEgPaTh_by_User.User" ON ('true'))) AS "data"