Languages-that-compile-to-sql Alternatives

Similar projects and alternatives to languages-that-compile-to-sql

Prisma

444 37,241 9.9 TypeScript languages-that-compile-to-sql VS Prisma

Next-generation ORM for Node.js & TypeScript | PostgreSQL, MySQL, MariaDB, SQL Server, SQLite, MongoDB and CockroachDB
sqlc

170 10,950 9.6 Go languages-that-compile-to-sql VS sqlc

Generate type-safe code from SQL
InfluxDB

www.influxdata.com featured

Power Real-Time Data Analytics at Scale. Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality.
migra

25 2,865 0.0 Python languages-that-compile-to-sql VS migra

Like diff but for PostgreSQL schemas
cornucopia

20 704 4.2 Rust languages-that-compile-to-sql VS cornucopia

Generate type-checked Rust from your PostgreSQL.
tusker

9 198 5.8 Python languages-that-compile-to-sql VS tusker

PostgreSQL migration management tool
postgres_migrator

7 78 5.1 Rust languages-that-compile-to-sql VS postgres_migrator

A postgres migration generator and runner that uses raw declarative sql.
refinery

6 1,213 7.1 Rust languages-that-compile-to-sql VS refinery

Powerful SQL migration toolkit for Rust. (by rust-db)
SaaSHub

www.saashub.com featured

SaaSHub - Software Alternatives and Reviews. SaaSHub helps you find the best software and product alternatives
pggen

11 269 6.6 Go languages-that-compile-to-sql VS pggen

Generate type-safe Go for any Postgres query. If Postgres can run the query, pggen can generate code for it.
safeql

4 15 0.0 Java languages-that-compile-to-sql VS safeql

Composable / async / functional / type-safe / parallel-pipelined queries and relations without SQL injection or N+1s. (by karmakaze)

NOTE: The number of mentions on this list indicates mentions on common posts plus user suggested alternatives. Hence, a higher number means a better languages-that-compile-to-sql alternative or higher similarity.

Suggest an alternative to languages-that-compile-to-sql

languages-that-compile-to-sql reviews and mentions

Posts with mentions or reviews of languages-that-compile-to-sql. We have used some of these posts to build our list of alternatives and similar projects. The last one was on 2023-01-06.

Ask HN: ORM or Native SQL?
10 projects | news.ycombinator.com | 6 Jan 2023

> Therefore, you can refactor your DB without changing app code.
Indeed, that's incredible! I tend to think that the actual layout of db tables a low level concern that is mainly driven by query performance and simplicity.
> - Type mapping is surprisingly hard to get right, especially with composite types and arrays and custom type converters. For example, a query might return multiple jsonb columns but the app code wants to parse them into different structs.
In Rust there's serde for converting json into structs (or enums if the shape of the json is complicated enough). Doesn't Go have a similar serialization/deserialization library?
> - Dynamic queries don't work with prepared statements. Prepared statements only support values, not identifiers or scalar SQL sub-queries, so the codegen layer needs a mechanism to template SQL. I haven't built this out yet but would like to.
In this case, what about stored procedures?
But, generally, instead of a template language for SQL, I would like to have a real compile-to-SQL higher level language, that could also do dynamic queries. The trouble with templating is that dynamic queries are hard to do in a type-safe manner, and it's hard to prevent generating invalid SQL when you have a bad template substitution (and then you get bad error messages from the db). There's a few languages like this do this https://github.com/ajnsit/languages-that-compile-to-sql but none fits the bill