desmos-labs / athena Goto Github PK

SELECT
  "_subs"."result_id",
  "_fld_resp"."root" AS "result"
FROM
  UNNEST(($1) :: uuid [ ], ($2) :: json [ ]) AS "_subs"("result_id", "result_vars")
  LEFT OUTER JOIN LATERAL (
    SELECT
      json_build_object($3, "profile"."root") AS "root"
    FROM
      (
        SELECT
          coalesce(json_agg("root"), $4) AS "root"
        FROM
          (
            SELECT
              row_to_json(
                (
                  SELECT
                    "_5_e"
                  FROM
                    (
                      SELECT
                        "_4_root.ar.root.application_links"."application_links" AS "application_links",
                        $5 AS "__typename"
                    ) AS "_5_e"
                )
              ) AS "root"
            FROM
              (
                SELECT
                  *
                FROM
                  "public"."profile"
                WHERE
                  (
                    ("public"."profile"."dtag") ILIKE ((("_subs"."result_vars" # > > ARRAY [ $6, $7 ])) :: text)
                  )
              ) AS "_0_root.base"
              LEFT OUTER JOIN LATERAL (
                SELECT
                  coalesce(json_agg("application_links"), $8) AS "application_links"
                FROM
                  (
                    SELECT
                      row_to_json(
                        (
                          SELECT
                            "_2_e"
                          FROM
                            (
                              SELECT
                                "_1_root.ar.root.application_links.base"."application" AS "application",
                                "_1_root.ar.root.application_links.base"."username" AS "username",
                                "_1_root.ar.root.application_links.base"."state" AS "state",
                                $9 AS "__typename"
                            ) AS "_2_e"
                        )
                      ) AS "application_links"
                    FROM
                      (
                        SELECT
                          *
                        FROM
                          "public"."application_link"
                        WHERE
                          (("_0_root.base"."address") = ("user_address"))
                      ) AS "_1_root.ar.root.application_links.base"
                  ) AS "_3_root.ar.root.application_links"
              ) AS "_4_root.ar.root.application_links" ON ($10)
          ) AS "_6_root"
      ) AS "profile"
  ) AS "_fld_resp" ON ($11)

SELECT
  "_subs"."result_id",
  "_fld_resp"."root" AS "result"
FROM
  UNNEST(($1) :: uuid [ ], ($2) :: json [ ]) AS "_subs"("result_id", "result_vars")
  LEFT OUTER JOIN LATERAL (
    SELECT
      json_build_object($3, "chain_link"."root") AS "root"
    FROM
      (
        SELECT
          coalesce(json_agg("root"), $4) AS "root"
        FROM
          (
            SELECT
              row_to_json(
                (
                  SELECT
                    "_4_e"
                  FROM
                    (
                      SELECT
                        "_0_root.base"."external_address" AS "external_address",
                        "_0_root.base"."user_address" AS "user_address",
                        "_0_root.base"."creation_time" AS "creation_time",
                        "_3_root.or.chain_config"."chain_config" AS "chain_config",
                        $5 AS "__typename"
                    ) AS "_4_e"
                )
              ) AS "root"
            FROM
              (
                SELECT
                  *
                FROM
                  "public"."chain_link"
                WHERE
                  (
                    ("public"."chain_link"."user_address") = ((("_subs"."result_vars" # > > ARRAY [ $6, $7 ])) :: text)
                  )
              ) AS "_0_root.base"
              LEFT OUTER JOIN LATERAL (
                SELECT
                  row_to_json(
                    (
                      SELECT
                        "_2_e"
                      FROM
                        (
                          SELECT
                            "_1_root.or.chain_config.base"."name" AS "name",
                            $8 AS "__typename"
                        ) AS "_2_e"
                    )
                  ) AS "chain_config"
                FROM
                  (
                    SELECT
                      *
                    FROM
                      "public"."chain_link_chain_config"
                    WHERE
                      (("_0_root.base"."chain_config_id") = ("id"))
                  ) AS "_1_root.or.chain_config.base"
              ) AS "_3_root.or.chain_config" ON ($9)
          ) AS "_5_root"
      ) AS "chain_link"
  ) AS "_fld_resp" ON ($10)

profile(where: {dtag: {_ilike: "luca"}}) {
    application_links {
      application
      username
    }
}

...
        },
        {
          "application": "twitch",
          "username": "lucag__"
        },
...