Three days before going open source, I deleted my parser's smartest feature.

333 lines. 6 functions. 12 passing tests. All green, all clever, all gone.

The feature worked. That was the problem.

The feature that knew too much

My PostgreSQL parser (valk-postgres-parser) extracts structure from SQL text: tables, columns, joins, filters. One of its analysis functions did something more ambitious. Give it a query like this: