1 reply

Issues with Drizzle SQL Module and Effect Compatibility

Having some issues with the drizzzle sql module.

Well, I figured out where to start, this is what's happening:

The new rqbv2 makes queries like :

sql: 'select "d0"."id" as "id", "d0"."name" as "name" from "users" as "d0"',

sql: 'select "d0"."id" as "id", "d0"."name" as "name" from "users" as "d0"',

and I think effect doesn't like it because it wants something like

sql: 'select "id", "name" from "users"',

sql: 'select "id", "name" from "users"',

In the effect/sql-drizzle internal folder:

statement = client.unsafe( prepared.query.sql, prepared.query.params )

statement = client.unsafe( prepared.query.sql, prepared.query.params )

should return fields, but is returning

undefined

undefined

I assume therefore the query engine wouldn't be supported?