# Comparison

> How Reylo compares with sqlc, sqlx, PgTyped, Prisma TypedSQL, SafeQL, TypeSQL and Postgres Typed SQL, from running each one on the same queries.

How Reylo compares with other tools that type SQL

Reylo isn't the first tool to type SQL: [sqlc](https://sqlc.dev), [sqlx](https://github.com/transact-rs/sqlx) and [PgTyped](https://pgtyped.dev) have typed queries for years, and [Prisma TypedSQL](https://www.prisma.io/docs/orm/prisma-client/using-raw-sql/typedsql), [SafeQL](https://safeql.dev), [TypeSQL](https://github.com/wsporto/typesql) and [Postgres Typed SQL](https://github.com/fli/postgres-typed-sql) do it too. This table comes from running each one on the same queries against real databases. Hover a cross or half circle to see what it answered, or a row's name to see what it asks.

| | Reylo | [sqlc](https://sqlc.dev) | [PgTyped](https://pgtyped.dev) | [sqlx](https://github.com/transact-rs/sqlx) | [TypedSQL](https://www.prisma.io/docs/orm/prisma-client/using-raw-sql/typedsql) | [SafeQL](https://safeql.dev) | [TypeSQL](https://github.com/wsporto/typesql) | [Postgres Typed SQL](https://github.com/fli/postgres-typed-sql) |
| --- | --- | --- | --- | --- | --- | --- | --- | --- |
| No codegen | yes | no | no | yes | no | partly | no | partly |
| Live database | yes | partly | yes | yes | yes | partly | yes | no |
| Nullable left joins | yes | partly | no | partly | partly | yes | partly | yes |
| Nullable expressions | yes | partly | no | partly | partly | partly | partly | yes |
| Parameter types | yes | yes | yes | partly | partly | partly | partly | yes |
| Nullable parameters | yes | partly | no | no | no | no | yes | no |
| Cardinality | yes | no | no | no | no | no | partly | partly |
| Nested JSON | yes | no | no | no | no | yes | partly | yes |
| JSON Schema types | yes | no | no | no | no | no | no | no |
| Postgres | yes | yes | yes | yes | yes | yes | yes | yes |
| MySQL | yes | yes | no | yes | yes | no | yes | no |
| SQLite | yes | yes | no | yes | yes | no | yes | no |
| DuckDB | yes | no | no | no | no | no | no | no |

Run on November 5, 2026, on each tool's latest release. [The queries, the answers and the code that runs them](https://github.com/colinhacks/reylo/tree/main/lab/compare) are in the repository.
