Sqlc: Compile SQL to type-safe code

#1

Post by wsc981 » Sun, Sep 08, 2024, 8:04 AM UTC

Sqlc: Compile SQL to type-safe code
sqlc.dev

Re: Sqlc: Compile SQL to type-safe code

#2

Post by geoka9 » Mon, Sep 09, 2024, 10:30 PM UTC

Have been enjoying go-jet that takes a different approach: analyzes the tables in your DB and generates a set of Golang structs that lets you write 100% Golang code that looks like 99% SQL. Genius!

https://github.com/go-jet/jet

Re: Sqlc: Compile SQL to type-safe code

#3

Post by pier25 » Mon, Sep 09, 2024, 10:36 PM UTC

I've been looking into sqlc lately for Go. Seems brilliant except for the lack of dynamic queries:

https://github.com/sqlc-dev/sqlc/discussions/364

Re: Sqlc: Compile SQL to type-safe code

#4

Post by dangoodmanUT » Mon, Sep 09, 2024, 10:39 PM UTC

this is great, until it breaks. For example it loses context on joins to allow columns that don't exist, which immediately breaks when you go to use it.

Re: Sqlc: Compile SQL to type-safe code

#5

Post by MaxRS » Mon, Sep 09, 2024, 10:48 PM UTC

Migrated from GORM to sqlc. We like the code generation approach with the simplistic abstractions.

https://github.com/helpwave/services/tree/main/services/task...

Re: Sqlc: Compile SQL to type-safe code

#6

Post by desiderantes » Mon, Sep 09, 2024, 10:56 PM UTC

geoka9 wrote: post #2

Have been enjoying go-jet that takes a different approach: analyzes the tables in your DB and generates a set of Golang structs that lets you write 100% Golang code that looks like 99% SQL. Genius! https://github.com/go-jet/jet

Oh, so it's jOOQ but for Go. Nice. Sadly it does not support most custom Postgres things.

Re: Sqlc: Compile SQL to type-safe code

#7

Post by sonu27 » Mon, Sep 09, 2024, 11:01 PM UTC

geoka9 wrote: post #2

Have been enjoying go-jet that takes a different approach: analyzes the tables in your DB and generates a set of Golang structs that lets you write 100% Golang code that looks like 99% SQL. Genius! https://github.com/go-jet/jet

Sqlboiler takes a similar approach https://github.com/volatiletech/sqlboiler

Re: Sqlc: Compile SQL to type-safe code

#8

Post by petcat » Mon, Sep 09, 2024, 11:10 PM UTC

I don't work with Go, but this seems like a dream. I really like the SQLx query macros in Rust. I would love for something like this

Re: Sqlc: Compile SQL to type-safe code

#9

Post by giovannibonetti » Mon, Sep 09, 2024, 11:13 PM UTC

Recently, a similar project (type-safe code generation from SQL) was released to Gleam [1].

[1] https://github.com/giacomocavalieri/squirrel

Re: Sqlc: Compile SQL to type-safe code

#10

Post by llimllib » Mon, Sep 09, 2024, 11:22 PM UTC

desiderantes wrote: post #6

geoka9 wrote: post #2

Have been enjoying go-jet that takes a different approach: analyzes the tables in your DB and generates a set of Golang structs that lets you write 100% Golang code that looks like 99% SQL. Genius! https://github.com/go-jet/jet

Oh, so it's jOOQ but for Go. Nice. Sadly it does not support most custom Postgres things.

XO doesn’t have them built-in, but it uses easily customizable templates.

I added support for a bunch of postgres fancy stuff in a previous app, it wasn’t too difficult

https://github.com/xo/xo