PgCore: QueryBuilder Issue
Has anyone come across this issue with
QueryBuilder
where if a subquery generated directly with a database connection (const connection = drizzle(client, { schema });
) works but if a subquery generated with a QueryBuilder
doesn't?2 Replies
Some context:
- Typescript has no issues with either approach (no errors)
- When I invoke
toSQL().params
on a query that uses that subquery generated directly from PostgresJsDatabase
it returns an empty array
- When I invoke toSQL().params
on a query that uses that subquery generated directly from QueryBuilder
it returns an array with 1 element: [Subquery]
Could you provide more info on how to reproduce this bug? An example query that you're having this issue with would be nice