sqlvalidator

sqlvalidator copied to clipboard

```python >>> import sqlvalidator >>> sql_query = sqlvalidator.parse("is_hidden is True and (is_active is True or is_zs is True)") >>> sql_query.is_valid() False >>> sql_query.errors [''] >>> sql_query = sqlvalidator.parse("select * from...

satels

Validation examples suggestions

1

Hi David-Wobrock, I really like the idea of this repository. I've tried this tool and found that the following query is validated as valid; maybe something to add to the...

ReinierKoops

Validation of bool for WHERE clause might be unnecessary

1

There are SQL queries that don't have a bool type in the where clause (e.g.: the usage of JSON_CONTAINS_PATH). https://github.com/David-Wobrock/sqlvalidator/blob/6b8732359e4c43c68d3550a10df5eea115417c1c/sqlvalidator/grammar/sql.py#L250 should be the place to change this.

tatulea