Console’s review
· Reviewed by David Mytton
What we like
Prevents mistakes by providing types for SQL queries. Understands fields types, joins, subqueries, aliases, and other advanced SQL features. Also supports dialects from databases like Planetscale, D1, AWS, etc. Enables autocomplete in your IDE. Migrations can also be written in TypeScript.
Tradeoffs
Only works with Postgres, MySQL & SQLite. A third-party project is needed if you want to auto-generate schema definitions.