Eliya Cohen
Eliya Cohen
I would happily introduce a PR if I could. But I've been cracking my head trying to figure out how to do it
Interesting... I'm using the following service for the CI in the project: ``` jobs: check: runs-on: ubuntu-latest services: postgres: image: postgres:14 env: POSTGRES_USER: postgres POSTGRES_PASSWORD: postgres POSTGRES_DB: postgres ports: -...
Thanks for the detailed report. This issue is similar to the other issue you've opened (https://github.com/ts-safeql/safeql/issues/99) so I'll answer for both of them: SafeQL tries to get the type for...
Correct. Ideally, I'm not against using sql fragments in code. I think I have no other option than implementing library-specific behavior { sqlFragmentSyntax: "postgres" | "slonik" | "..." }` to...
I [tweeted](https://twitter.com/CoEliya/status/1608556346533875713) about my progress on this matter. Hopefully I'll push a V1 for this.
Hi @Eprince-hub Thanks for the support 🙂 I think I need to rewrite my implementation for SQL fragments so it can be more robust and easier to maintain. SafeQL doesn't...
@Eprince-hub another workaround would be to simply use `= ANY` instead of `IN`: ```ts export async function query(a: number[]) { return await sql` SELECT * FROM try_safe_ql WHERE id =...
I have a private branch that allows 3rd party providers (such as DrizzleORM, kysely, postgres-js and slonik) to "translate" their expressions to sql syntax. I started with postgres-js, but it's...
Good catch. As a workaround for now, you could wrap the condition with `coalesce`. I will push a new version soon that should fix it.
@karlhorky The above-mentioned example is a bit more complex since you can't tell whether it's nullable or not just by the AST. If the column reference is nullable, then `col...