[hyperbrainer]

I have never used SQLx, but the best SQL integration I can think of is LINQ. How does this compare to that?

[S04dKHzrKT]

In the dotnet world, SQLx is more analogous to F# type providers like FSharp.Data.SqlClient , SQLProvider or Rezoom.SQL.

[RonanSoleste]

Different products. I would not compare them. LINQ is more like Diesel (https://diesel.rs/)

[maxbond]

To expand, SQLx isn't an ORM or query builder, what it does is allow you to write raw SQL with compile-time guarantees of type safety. It does this by connecting to a dev database at compile time & uses SQL's introspection features (specifically, by preparing a statement[1]) to analyze your queries. (It can also cache this information to check without a database available, and has a basic migration facility.)

[1] https://github.com/launchbadge/sqlx/blob/main/FAQ.md#how-do-...