Further reading

SQL parsing on Snowflake
Mastering SQL Parser: Deep Dive into Functionality, Use Cases, and Practical Examples with FlowHigh
Automatically detect bad SQL. Static and dynamic analysis of SQL code