safeql
safeql copied to clipboard
Validate and auto-generate TypeScript types from raw SQL queries in PostgreSQL.
**Is your feature request related to a problem? Please describe.** PostgreSQL `FILTER` clauses don't currently change the type of the resulting rows Eg. `animalFoods.id` can also be `null` here, even...
I should probably add basic documentation of how to run SafeQL in CI
**Describe the bug** When comparing two not null timestamps, the result will never be null, but SafeQL interprets it at nullable. **To Reproduce** Steps to reproduce the behavior: Create a...
SafeQl recognizes fields as nullable when inner joining with a materialized view:  **The View:** ``` CREATE MATERIALIZED VIEW issues_base AS SELECT issue.id AS issue_id, issue.cve_code, image.name AS image_name, image.id...
Today SafeQL supports only raw SQL migration files. (In the `migrationsDir`) As a TypeORM user, I would like to also have a support of TS migrations files. Their structure simple:...
**Describe the bug** SafeQL throws an error when using the `sql()` helper in `Postgres`. This is a [feature that is supported in postgres.js](https://github.com/porsager/postgres#quick-primer-on-interpolation) but it seems like SafeQL doesn't allow...
I'd like to use this safeql with Drizzle ORM(https://orm.drizzle.team/), which also has `sql` function
**Describe the bug** When defining in `.eslintrc.js` file under `overrides.types` a mapping of an enum, safeql doesn't recognize it when the enum is used in a query (and not as...