A SQL engine, from scratch

This runs a real query engine in your browser: a tokenizer, a recursive-descent parser, and an executor, all hand-written, no database and no libraries. It supports SELECT, WHERE with AND / OR and parentheses, ORDER BY, and LIMIT. Type a query and it will show you the results plus the tokens and syntax tree it built along the way. It is the browser cousin of my pysql_engine, which does the same thing in pure Python.

Table: employees(id, name, dept, salary, age), 10 rows.

← All experiments