tobymao/sqlglot

Issues

• The sha256 function is not recognized correctly in duckdb dialect.

  #4815 opened a month ago by muuuuwa
  0

• clickhouse: properly support Aggregate Combinators

  #4814 opened a month ago by pkit
  3

• Support parsing PUT/GET queries to upload/download files from stages (Snowflake)

  #4813 opened a month ago by whummer
  1

• regexp_extract_all results in excessive backslashes after parse_one and transpile

  #4810 opened a month ago by dominikpeter
  3

• PostgreSQL DISTINCT ON clause qualification

  #4791 opened a month ago by Fosly
  16

• Support `and()`, `or()` functions (ClickHouse)

  #4803 opened a month ago by xtess16
  0

• SELECT TOP 10 PERCENT doesn't parse

  #4793 opened a month ago by gleb-daax
  0

• How to obtain all table names from a SQL query?

  #4799 opened a month ago by galenseilisnh
  3

• Type coercion doesn't take type parameters into account

  #4792 opened a month ago by georgesittas
  0

• execute is crashing with bigquery unnesting

  #4788 opened a month ago by thejens
  1

• Adding limit to a UNION SQL outputs incorrect sql in "tsql" dialect

  #4786 opened a month ago by aman-wisdom
  1

• bigquery: transpile to bigquery failing with UBIGINT token

  #4785 opened a month ago by marshallkd
  1

• clickhouse: support the new json dynamic type resolution syntax

  #4776 opened a month ago by pkit
  3

• How to define the table for a column that come from two tables

  #4781 opened a month ago by ClaudioLucioLopes
  1

• ClickHouse dialect raises an error when traversing with scopes on a query with tables with the same name

  #4769 opened a month ago by dzianis-atamanchuk
  1

• Failed to parse SQL (postgres) with commented out semicolon

  #4762 opened 2 months ago by dbittenbender
  3

• Two-argument version of clickhouse maxIf, minIf, countIf

  #4778 opened 2 months ago by dnbnero
  5

• duckdb: number can be underscored

  #4777 opened 2 months ago by mscolnick
  0

• ParseError when handling PostgreSQL recursive CTE with SEARCH DEPTH FIRST BY

  #4763 opened 2 months ago by psanjeev-cellino
  0

• SQLGlot incorrectly handles table aliases: includes some aliases in table output while missing others

  #4771 opened 2 months ago by gh-tvenkataramana
  3

• Invalid SQL generated when using the json_object function

  #4770 opened 2 months ago by ori-n
  0

• DROP INDEX - it mixing between index name and table name

  #4764 opened 2 months ago by AhlamHani
  1

• parsing failure for USE (snowflake)

  #4760 opened 2 months ago by merlindso
  0

• Failed parsing of "IF NOT EXISTS" when it appears after the create

  #4759 opened 2 months ago by merlindso
  1

• Error while convert mysql CURDATE() to postgres: function curdate() does not exist

  #4758 opened 2 months ago by hxxxxh
  0

• [clickhouse] `WITH <expression> AS <identifier>` not correctly handled

  #4757 opened 2 months ago by martijnthe
  2

• Inconsistent tokenization results between Python and Rust when handling full-width spaces

  #4748 opened 2 months ago by gesoges0
  0

• ClickHouse: Unknown function ARRAY_CONCAT.

  #4751 opened 2 months ago by maximlipiev
  0

• Sql generated by expand function in expression package is not correct for oracle

  #4752 opened 2 months ago by subhradip-bose
  1

• Trailing comma after table name causes error in Snowflake dialect

  #4750 opened 2 months ago by omerhadari
  1

• Incorrect binary conversion for duckdb

  #4739 opened 2 months ago by sk-
  0

• Clickhouse dialect to BOTH as trim type if it's not specified

  #4746 opened 2 months ago by sleshJdev
  0

• Handle Oracle DUAL table

  #4745 opened 2 months ago by sleshJdev
  3

• SQL Pipeline Syntax

  #4742 opened 2 months ago by aersam
  1

• `qualify` doesn't play nice with `GenerateSeries`

  #4740 opened 2 months ago by martijnthe
  2

• SQL built-in functions supported by the executor?

  #4738 opened 2 months ago by DiTo97
  1

• Oracle trunc function support by ClickHouse dialect

  #4733 opened 2 months ago by sleshJdev
  1

• SQL generation stuck when transpiling qualify to spark

  #4735 opened 2 months ago by omerhadari
  0

• SQL Server to Postgres CREATE TABLE transpilation issues

  #4715 opened 2 months ago by amachanic
  2

• Bud in translation of any between Postgres and Athena

  #4731 opened 2 months ago by dor-bernstein
  1

• double `INTERVAL` in `date_add` when performing a roundtrip with `dialect="duckdb"`

  #4728 opened 2 months ago by whao89
  0

• impala dialect

  #4729 opened 2 months ago by KiteJogRunner
  1

• DuckDB 1.2.0 Compatbility

  #4710 opened 2 months ago by eakmanrq
  0

• not support impala dialect ,when support?

  #4726 opened 2 months ago by KiteJogRunner
  2

• Parsing fails for DDL with AggregateFunctions containing a keyword

  #4723 opened 2 months ago by dorranh
  0

• eliminate_join_marks removes all existing joins if no columns with join mark exist

  #4721 opened 2 months ago by snovik75
  0

• spark sql translate presto sql （Function 'add_months' not registered）

  #4720 opened 2 months ago by cnmrzhou
  1

• lineage() fails in CTE with SELECT *

  #4716 opened 2 months ago by dbittenbender
  10

• How to parse at the rule level?

  #4714 opened 2 months ago by RedTailedHawk
  1

• Error in transpile(stmt, read="tsql", write="duckdb", identify=False, pretty=True)

  #4711 opened 2 months ago by magneto-81
  1