What's the best practice in terms of CRUD operations with SQL databases?

[rancid copper]

I was looking at this https://github.com/jschaf/pggen to generate types from psql automatically. This way I can code faster and automate some grunt work. What do you think?

[noble hamlet]

so it's like sqlc but it doesnt generate the queries?

https://sqlc.dev

there is an sqlc website you can use, dump schema and queries to bootstrap a project

[rancid copper]

thanks will look into it

how does it work with relationships?

[noble hamlet]

there was an issue with left joins for a while, but I think its solved?

pggen is probably better for postgres specific workload, but it will fall apart if you use cockroachdb for example

[rancid copper]

any thought on Ent?

[stable garden]

Or you can write your own queries and use Proteus to hook them together.
https://github.com/jonbodner/proteus

[rancid copper]

will look into this as well thank you