Jul 31, 2024
5 stories
Parsing strings as SQL with TypeScript
This series will guide you through building a SQL parser in TypeScript from the ground up. We will be covering the type system, how it allows both defined (query builders) and inferred (just simple strings) parsing as well as schema management, validation and much more!
We finally add data into the databases as well as enabling customizations to our parsing logic!
The fourth article where we finally integrate with Postgres and MySQL to execute our abstract queries.
The third article where we bring together the AST, schemas and TypeScript magic to parse raw strings into SQL objects.
The second article in the series, working on how to define database schemas
The first article in the series, introducing the idea and building blocks!