issues Search Results · repo:David-Wobrock/sqlvalidator language:Python
Filter by
34 results
(84 ms)34 results
inDavid-Wobrock/sqlvalidator (press backspace or delete to remove)SQLQuery.is_valid() raises an exception for with query statements:
from sqlvalidator.sql_validator import SQLQuery
sql_with = with a as (select * from b) select * from a
sql_query = SQLQuery(sql_with) ...
- IlyaMichlin
- Opened on Feb 20, 2024
- #53
Example
import sqlvalidator
invalid_query = SELECT ** FROM FROM FROM ***;
sql_query = sqlvalidator.parse(invalid_query)
sql_query.is_valid()
- fruttasecca
- Opened on Mar 15, 2023
- #51
I found the following case which seems to me to be a false negative. According to PG s documentation, setting LIMIT to
either NULL or ALL should result in fetching all available rows (and it does).
import ...
- castagninojose
- Opened on Jan 10, 2023
- #49
Using Python3.8 in a virtual environment, this query is showing an error even though it s working properly for Google
BigQuery:
query =
SELECT
CAST(
DATE_ADD(invoice_date, INTERVAL payment_term ...
- alexandregirbal-loxsolution
- 3
- Opened on Jun 7, 2022
- #46
I tried to dig into the code and find some breadcrumbs but I couldn t get anywhere...
import sqlvalidator
query = SELECT * FROM table WHERE cast(start_time as date) dateadd(year,-3,now());
sql_query ...
- mikeoverjet
- 1
- Opened on Apr 27, 2022
- #44
Using python 3.9 and sqlvalidator==0.0.18
When running sqlvalidator.parse(query).is_valid() i m getting
def _validate(self):
self.validated = True
try:
self.errors = self.sql_query.validate() ...
- timotta
- 4
- Opened on Mar 23, 2022
- #39
Hi David!
Thank you for sqlvalidator! :) The following query seems correct:
SELECT
CASE
WHEN CASE
WHEN code = 1 THEN VALID
WHEN code = 2 THEN INVALID
END
= VALID THEN OK
ELSE ...
- SofienBenAyed
- Opened on Mar 18, 2022
- #38
Hello David 👋
I just noticed that comments are not handled correctly when formatting the SQL queries. For example
SELECT * FROM table_a
WHERE user_name= john doe
/* just a comment */
ORDER BY user_id ...
- aymen-k
- Opened on Feb 11, 2022
- #37
Hi David,
https://cloud.google.com/bigquery/docs/reference/standard-sql/query-syntax#select_replace
sqlvalidator 0.0.18:
- SELECT * REPLACE( bar AS foo)
+ SELECT * REPLACE
A quick unit test causes ...
- ybastide
- Opened on Feb 10, 2022
- #36
It seems SQLValidator has issues with array access notation on the result of a function call (both with OFFSET and
SAFE_OFFSET)
-- Before
SELECT SPLIT(list, : )[SAFE_OFFSET(0)] item
FROM mytable
-- ...
- rgehan
- Opened on Dec 6, 2021
- #35
Learn how you can use GitHub Issues to plan and track your work.
Save views for sprints, backlogs, teams, or releases. Rank, sort, and filter issues to suit the occasion. The possibilities are endless.Learn more about GitHub IssuesProTip!
Press the /
key to activate the search input again and adjust your query.Learn how you can use GitHub Issues to plan and track your work.
Save views for sprints, backlogs, teams, or releases. Rank, sort, and filter issues to suit the occasion. The possibilities are endless.Learn more about GitHub IssuesProTip!
Press the /
key to activate the search input again and adjust your query.