search

xnuinside / simple-ddl-parser

Simple DDL Parser to parse SQL (HQL, TSQL, AWS Redshift, BigQuery, Snowflake and other dialects) ddl files to json/python dict with full information about columns: types, defaults, primary keys, etc. & table properties, types, domains, etc.
MIT License
179 stars 40 forks source link

SQLite Dialect #189

Closed leandromferreiraUSP closed 1 year ago

leandromferreiraUSP commented 1 year ago

Is your feature request related to a problem? Please describe.

The most common database for Python is SQLite and SQLite is to simple in or dialect

Describe the solution you'd like

A support to SQLite dialect

Describe alternatives you've considered

Today I use annother dialect

Additional context

Thks for your great work Iuliia Volkova.!!

xnuinside commented 1 year ago

@leandromferreiraUSP, hi! Thanks for opening the issue. Did you have a some samples or maybe link to the doc where is placed difference between common SQL & SQLite dialect? I thought that SQLite don't have special syntax or statements.

leandromferreiraUSP commented 1 year ago

Oi Iuliia. Muito obrigado pela sua resposta. Não percebi que tem uma implementação para SQL ANSI em sua biblioteca, e você está certo, SQLite tem o mesmo dialeto que ANSI SQL-92.

leandromferreiraUSP commented 1 year ago

Sorry, I put an answer in portuguese. Now I will put in English.

Hey Iuliia. Thank You very much for your answer. I did not notice that it has an implementation for SQL ANSI in your library, and you are right, SQLite has the same dialect that ANSI SQL-92.