Properly inferring Prepared Statement Return Type when executing a query
Hi everyone 🙂
I'm working on a SvelteKit project with Drizzle ORM and i'm trying to extract some of the queries to prepared statements.
There's probably something i'm doing wrong, yet when i execute the prepared statement in my codebase - i'm loosing the inferred model return type.
Meaning,
const data = await ps.execute() | ps.all() | ps.execute({ ph: 'ph'}) return type is unknown....
Error When Using isNull Filter
Hello! I am getting an in drizzle kit when filtering by
isNull on a nullable column. Any idea why this might be?
Thanks!
Error: syntax error at or near "$1"...
how to make order work with selectDistinctOn in pg?
When I add order by to my query it gives error that "initial order by prop should be the same with distinct on prop", but i dont want first orderby parameter to be tasks.id. i want it to be as on the comment. Could you please let me know how i can achive it?
( And when i try to make the query with distincton a subquery, then use it in new one with orderby, i am getting this error: "error": "You tried to reference "assignees" field from a subquery, which is a raw SQL field, but it doesn't have an alias declared. Please add an alias to the field using ".as('alias')" method.")
```ts...
Drizzle studio doesn't handle timestamps properly
I was trying to create some records into my users table:
``
CREATE TABLE users (
id` integer PRIMARY KEY AUTOINCREMENT NOT NULL,...