SQLite Dialect

[leandromferreiraUSP]

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]

@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]

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]

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.