Pysqlutil 1.0.1

Description:

pysqlutil 1.0.1

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 .