Open Source SQL Parsers

1

Apache Hive

Apache Calcite is a popular parser/optimizer that is used in popular databases and query engines Like Apache Hive, BlazingSQL and many others.

#Databases #Big Data #Data Warehousing 8 social mentions

2

Apache Calcite

There are multiple projects that maintain parsers for popular open source databases like MySQL and Postgres. For other Open source databases, the grammar can be extracted from the open-source project. For commercial databases, the only Option is to reverse engineer the complete grammar. There are SQL parser/optimizer platforms like Apache Calcite That help to reduce the effort to implement the SQL dialect of your choice.

#Databases #Data Dashboard #Relational Databases 12 social mentions

3

ANTLR

An alternate approach is to implement the SQL grammar using parser generators like ANTLR. There Are similar open source parser generators in other popular languages.

#Parser Generator #Developer Tools #Monitoring Tools 2 social mentions