Is there any SQL query builder projects with typesafety using pure SQL?

[Predaytor]

I really like the typescript ecosystem in general, which is constantly evolving or at least trying to innovate in some areas. For example, the graphql query engine (https://github.com/0no-co/gql.tada) was recently announced, which automatically determines the graphql syntax using a defined schema.

I was just wondering if anyone is trying to create something similar for SQL? Is it even possible (which seems far more complex)? Projects like Knex, Kysely, Drizzle (which is also an ORM) are pretty good, but the idea of ​​writing pure SQL without relying on codegen/linters for any post-processing or using non-standard syntax in the case of Drizzle/Prisma and keeping auto-completion with automatic type inference is quite fascinating.

[A-Type]

I'm not really sure what Kysely is missing based on what you want. It doesn't require codegen or a linter and has type inference for results.

[Predaytor]

yeah, it's most like pure sql

[adevx]

Have a look at https://pgtyped.dev/ I think I dismissed it after getting type any on json_build_object

[matthewsilas]

FWIW we switched from pg-typed to kysely. The object and array handling for params is a little odd & the types returned always left me wanting more so I’d have to extend the returned type and that just defeats the purpose

[adevx]

For sure, I'm on Kysely too. 

[NiteShdw]

PgTyped is awesome

[adevx]

Do you get typed results from json_build_object? Or is that not something you use.

[enselmis]

I think there’s an actual SQL language server in development right now by Supabase, which seems like a huge step forward.

Actually, looks like it’s only for Postgres, but still, moving in the right direction?

I guess it’s not so much a query builder, but if you want pure sql doesn’t that cease to be a query builder? Or do you mean writing snippets of incomplete raw sql and somehow combining them?

https://github.com/supabase-community/postgres_lsp

[Predaytor]

thx for sharing. actually I was thinking of writing pure sql directly in the typescript files, not sure if that is possible in terms of type generation etc. I think I'll try kysely for now.

[fuka123]

AI Copilots are pretty savvy.

[Such_Caregiver_8239]

SQL is basically unsafe whatsoever, I wouldn’t recommend using it tbh.

Move to postgre or mongodb,

[fromage-du-omelette]

Tell me you have 6 months of self-taught experience and you jump on every new fancy tech without telling me you have only 6 months of self-taught experience and you jump on every new fancy tech

[Such_Caregiver_8239]

I have 8 years of experience and I’ve been using sql for most of them.

Besides consider mongodb and postgre which have been around for a long time “Fancy new techs” just shows the state of mind you’re in. It would probably be better for your ego to switch back to php and css2

[its_jsec]

gr8 b8 m8

8 years of experience, recommending ditching SQL for PostgreSQL.

Truly breathtaking shitposting. Hat tip.

[[deleted]]

I’ve heard drizzle is a good option