pysqlutil 1.0.1

parse sql , compare two .sql file , generate optimization hint for your sql and various other utilities

dot.parser

Project Phase One:

• SQL ( Parsing SQL ) Till now I could only managed to create SQL Parser
• Phase Status - initial Development
• Due to beta version release you might face some difficulties

SQL Dialects Supported

• MySQL
• PostreSQL ( Redshift in progress )
• Sqlite

---

How to use this python module

pip install pysqlutil

Extracting raw sql-metadata tokens

from pysqlutil import parser

# extract raw sql-metadata tokens
parser("SELECT * FROM test_table").tokens
parser("SELECT test, id FROM test_table1,test_table2").columns
# you will get column names

parser_object = parser("<your custom SQL>")
parser_object.columns
# you will get column names as a list

# but you can still extract aliases names
parser_object.columns_aliases
# column alias list 

Soon , new featurers will be included like SQL File compare , DDL Compare , Analyze and optimize SQL

Future Release list

• Jan-2023 : SQL Compare , Compare two versions of DDL
• Feb-2023 : GUI Support .