@fizzog/sqlx is a lightweight SQL engine written in TypeScript that provides a simple, educational implementation of core database concepts. The project accepts SQL statements, tokenizes the input using a custom lexer, parses the tokens into an abstract syntax tree (AST), and executes the resulting statements against an in-memory database engine. It supports basic SQL operations including creating tables, inserting records, selecting data, updating rows, deleting records, and filtering results with conditional expressions. The goal of the project is to explore how SQL databases work internally by building the fundamental components of a query engine from scratch while providing a simple JavaScript/TypeScript API for applications to execute SQL commands.

See documentation here: @fizzog/SQLx