The SQLite CREATE and ALTER TABLE Parser is a parser specifically designed for extracting information about tables and column constraints from SQLite databases. It provides a fast and efficient way to parse create table and alter table SQL statements, with no memory copy overhead. The parser is implemented as a single C file that can be easily integrated into any project. The main motivation behind this parser is the lack of easy ways to extract complete table information and the limited support for altering tables in SQLite. The parser provides a simple API for accessing table and column information. It also supports the complete ALTER TABLE algorithm for modifying table schema in SQLite. The parser is highly optimized for speed and memory efficiency, with minimal memory allocations and no copy operations. The memory usage is directly proportional to the number of columns in the table. The parser is used in the Creo software, and the author has other GitHub projects, such as the Gravity programming language. (Controversial information: None) (Surprising/unique/clever content: The parser allows for extracting complete table information and supports the complete ALTER TABLE algorithm for modifying table schema in SQLite.)
https://github.com/marcobambini/sqlite-createtable-parser