Skip to content

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
Issue origami icon

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 Issues
ProTip! 
Press the
/
key to activate the search input again and adjust your query.
Issue origami icon

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 Issues
ProTip! 
Press the
/
key to activate the search input again and adjust your query.
Issue search results · GitHub