Pure-C# SQL engine
KullGames TinySQL
A real SQL parser + relational-algebra executor - powered by OnlyCSharp 1.8
(DataScience.Databases.DatabaseTheory: SqlParser + RelationalAlgebra). SQL text is parsed
into a ProjectionNode → SelectionNode → ScanNode algebra tree and executed against an in-memory
Relation. The output below is the verified server-side run.
KULLGAMES TINYSQL -- a real SQL parser + relational-algebra executor ========================================================================================== Table 'employees' -- 6 rows, columns: name, dept, salary (name=Alice, dept=Engineering, salary=72000) (name=Bob, dept=Sales, salary=58000) (name=Carol, dept=Engineering, salary=95000) (name=Dave, dept=Sales, salary=45000) (name=Eve, dept=Engineering, salary=61000) (name=Frank, dept=Marketing, salary=83000) ========================================================================================== SQL> SELECT name, salary FROM employees WHERE salary > 60000 name | salary ------------------ Alice | 72000 Carol | 95000 Eve | 61000 Frank | 83000 (4 row(s), 2 column(s)) SQL> SELECT * FROM employees WHERE dept = 'Engineering' name | dept | salary -------------------------------- Alice | Engineering | 72000 Carol | Engineering | 95000 Eve | Engineering | 61000 (3 row(s), 3 column(s)) SQL> SELECT name FROM employees WHERE salary < 50000 name -------- Dave (1 row(s), 1 column(s))