To Reproduce

1. Opened test database with pre-created table and record
2. edited record
3. SQL.exception without details

Expected behavior
updated record

Screenshots

Desktop (please complete the following information):

• OS: Windows
• DataGrip 2021.2.4
• Version 0.1.0

Additional info

Captured exchange during update, but see no update at all. Just "SELECT 1"

Describe the bug
DataGrip can not query SQL tables with lowercase characters in table names.

To Reproduce

1. Create a "table" with lowercase characters
2. Add Tarantool instance to DataGrip
3. Try to open the "table."
4. See an error such as "No such table" with an uppercase name.

Expected behavior
DataGrip can handle lowercase named tables.

Screenshots

Is your feature request related to a problem? Please describe.
The current implementation is based on ANSI SQL 92 and misses some core constructions of Tarantool SQL.

Describe the solution you'd like
We need to use Grammar-Kit to create BNF grammar. Grammar-kit can generate common Psi elements, lexer, and parser out of it.

Describe alternatives you've considered
Using a grammar kit is a must - other options will demand much more work.

Is your feature request related to a problem? Please describe.
Tarantool should have syntax highlighting to be useful in Intellij.

Describe the solution you'd like
Develop SyntaxHighglighterProvider for Tarantool SQL.

There is an extension for that, see
com.intellij.database.Dbms.DbmsBean

Plugin will return Input contains invalid type value -40 any space's field that has datatype uuid e.g.

EXAMPLE_TABLE
(
    ID UUID,
    NAME STRING
); 
//Assume success created table  EXAMPLE_TABLE

SELECT ID FROM EXAMPLE_TABLE  //Not work
SELECT NAME FROM EXAMPLE_TABLE  //Work

Screen
ide.log.txt

Is your feature request related to a problem? Please describe.
Knowledge gathering about database-impl and database-dialects is a prerequisite before implementing BNF grammar for Tarantool.

Describe the solution you'd like
Go through generator modules, investigate grammar-kit, investigate SQL92 dialect implementation.

Describe alternatives you've considered
I cannot see an alternative

Is your feature request related to a problem? Please describe.
SQL shortcuts and refactoring are missing.

Describe the solution you'd like
Describe intentions precisely for Tarantool. We can use SQL92 intentions and inspections from JetBrains implementation.