You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Is your feature request related to a problem? Please describe.
The way we do nested questions keeps the fields of the subqueries static, but on columnar databases we should be only picking the columns we're using in the top level query
Describe the solution you'd like
If we're using columnar DB's, instead of
SELECT
"source"."id" AS "id",
"source"."rating" AS "rating",
"source"."rating_mapped" AS "rating_mapped",
"source"."body" AS "body"
FROM
(
SELECT
"public"."feedback"."id" AS "id",
"public"."feedback"."account_id" AS "account_id",
"public"."feedback"."email" AS "email",
"public"."feedback"."date_received" AS "date_received",
"public"."feedback"."rating" AS "rating",
"public"."feedback"."rating_mapped" AS "rating_mapped",
"public"."feedback"."body" AS "body"
FROM
"public"."feedback"
) AS "source"
LIMIT
1048575
the query should be
SELECT
"source"."id" AS "id",
"source"."rating" AS "rating",
"source"."rating_mapped" AS "rating_mapped",
"source"."body" AS "body"
FROM
(
SELECT
"public"."feedback"."id" AS "id",
"public"."feedback"."rating" AS "rating",
"public"."feedback"."rating_mapped" AS "rating_mapped",
"public"."feedback"."body" AS "body"
FROM
"public"."feedback"
) AS "source"
LIMIT
1048575
Describe alternatives you've considered
None
How important is this feature to you?
NA
Additional context
NA
The text was updated successfully, but these errors were encountered:
Is your feature request related to a problem? Please describe.
The way we do nested questions keeps the fields of the subqueries static, but on columnar databases we should be only picking the columns we're using in the top level query
Describe the solution you'd like
If we're using columnar DB's, instead of
the query should be
Describe alternatives you've considered
None
How important is this feature to you?
NA
Additional context
NA
The text was updated successfully, but these errors were encountered: