Ecosyste.ms: Issues
An open API service for providing issue and pull request metadata for open source projects.
GitHub / tobymao/sqlglot issues and pull requests
#3955 - Fix the regexp_like trans to RLIKE function
Pull Request -
State: closed - Opened by hellozepp about 1 month ago
#3954 - fix(oracle): Revert NVL() being parsed into exp.Anonymous
Pull Request -
State: closed - Opened by VaggelisD about 1 month ago
#3953 - Column Lineage Analysis
Issue -
State: closed - Opened by bkleck about 1 month ago
- 9 comments
#3952 - Transpile Oracle nvl function to ClickHouse ifNull
Issue -
State: closed - Opened by sleshJdev about 1 month ago
- 2 comments
#3951 - Fix!: mysql/tsql datetime precision, formatting, exp.AtTimeZone
Pull Request -
State: open - Opened by erindru about 1 month ago
#3950 - Failed to parse oracle /* /* */ comment
Issue -
State: closed - Opened by sleshJdev about 1 month ago
#3949 - fix(optimizer): convert TsOrDsToDate to Cast more conservatively
Pull Request -
State: closed - Opened by barakalon about 1 month ago
#3948 - Transpile Oracle "with core_sql as (select 1)" to ClickHouse failed to parse any statement following CTE
Issue -
State: closed - Opened by sleshJdev about 1 month ago
- 2 comments
#3947 - Fix(duckdb): TIME does not support modifiers
Pull Request -
State: closed - Opened by georgesittas about 1 month ago
#3946 - fix(bigquery): Map strftime %-d to BQ %e
Pull Request -
State: closed - Opened by VaggelisD about 1 month ago
#3945 - Fix(parser): Support sqls with DESCRIBE partition
Pull Request -
State: closed - Opened by gp1105739 about 1 month ago
- 2 comments
#3944 - Refactor(clickhouse)!: attach INTERPOLATE expressions to WithFill
Pull Request -
State: closed - Opened by georgesittas about 1 month ago
#3943 - Fix(optimizer): expand alias refs recursive CTE edge case patch
Pull Request -
State: closed - Opened by georgesittas about 1 month ago
#3942 - Fix!: Redshift date format
Pull Request -
State: closed - Opened by erindru about 1 month ago
#3941 - Failed to parse a statement with desc partition
Issue -
State: closed - Opened by gp1105739 about 1 month ago
- 1 comment
#3940 - Fix!: exp.Merge condition for Trino/Postgres
Pull Request -
State: closed - Opened by erindru about 1 month ago
#3939 - Feat(clickhouse): add support for "@"-style parameters
Pull Request -
State: closed - Opened by georgesittas about 1 month ago
#3938 - Feat!: Add timezone support to exp.TimeStrToTime
Pull Request -
State: closed - Opened by erindru about 1 month ago
#3937 - Fix(parser): allow complex expressions for UNPIVOT alias
Pull Request -
State: closed - Opened by georgesittas about 1 month ago
#3936 - Failure to parse complex UNPIVOT statement with Oracle Query
Issue -
State: closed - Opened by dbittenbender about 1 month ago
#3935 - Fix(oracle)!: preserve SYSDATE
Pull Request -
State: closed - Opened by georgesittas about 1 month ago
#3934 - in ORACLE queries, SYSDATE is replaced by CURRENT_TIMESTAMP. These 2 functions are not the same.
Issue -
State: closed - Opened by Hal-H2Apps about 1 month ago
#3933 - ORACLE : Column name in group by replaced by the column number when an alias with the same name as the column is used
Issue -
State: closed - Opened by Hal-H2Apps about 1 month ago
- 2 comments
#3932 - Add support for `MINUS` keyword in `Spark`
Pull Request -
State: closed - Opened by renardeinside about 1 month ago
- 2 comments
#3931 - fix(duckdb): Fix exp.Unnest generation for BQ's nested arrays
Pull Request -
State: closed - Opened by VaggelisD about 1 month ago
- 1 comment
#3930 - Add `MINUS` keyword support for `Spark` and related dialects
Issue -
State: closed - Opened by renardeinside about 1 month ago
#3929 - Fix group by and cancel
Pull Request -
State: closed - Opened by hellozepp about 1 month ago
#3928 - Simplify the lineage output in case of cte
Issue -
State: closed - Opened by ludo9511 about 1 month ago
- 3 comments
#3927 - Feat!: skip nullable comparison in is_type by default
Pull Request -
State: closed - Opened by georgesittas about 1 month ago
#3926 - Refactor: iteratively generate binary expressions
Pull Request -
State: closed - Opened by MatMoore about 2 months ago
- 7 comments
#3925 - Sqlglot optimize is not working.
Issue -
State: closed - Opened by santoshvarma about 2 months ago
- 1 comment
#3924 - Fix(clickhouse)!: use creatable kind mapping dict for schema<-->database substitution
Pull Request -
State: closed - Opened by treysp about 2 months ago
#3923 - add benchmark for tree-sitter-sql
Issue -
State: closed - Opened by milahu about 2 months ago
- 1 comment
#3922 - Is Splunk SPL a dialcect that might be added soon?
Issue -
State: closed - Opened by anirbans403 about 2 months ago
- 1 comment
#3921 - Refactor(clickhouse)!: improve transpilation of nullable/non-nullable data types
Pull Request -
State: closed - Opened by georgesittas about 2 months ago
#3920 - Fix(clickhouse): add timestamptz type mapping
Pull Request -
State: closed - Opened by treysp about 2 months ago
#3919 - Refactor(clickhouse): transpile TRY_CAST(x AS T) to CAST(x AS Nullable(T))
Pull Request -
State: closed - Opened by georgesittas about 2 months ago
#3918 - Fix(optimizer)!: infer set op types more accurately
Pull Request -
State: closed - Opened by georgesittas about 2 months ago
#3917 - Fix(clickhouse): make try_cast toXXXOrNull() functions case-specific
Pull Request -
State: closed - Opened by treysp about 2 months ago
#3916 - Null order in union seems to affect data type inference
Issue -
State: closed - Opened by racevedoo about 2 months ago
- 1 comment
#3915 - Annotate types not working with subqueries/CTEs
Issue -
State: closed - Opened by racevedoo about 2 months ago
- 2 comments
#3914 - NULL LAST DESC gives error - invalid expression in parse_one using read = postgres
Issue -
State: closed - Opened by vishaldas-datafacade about 2 months ago
- 2 comments
#3913 - Feat(clickhouse): add support for TryCast generation
Pull Request -
State: closed - Opened by georgesittas about 2 months ago
#3912 - Fix(clickhouse)!: treat DATABASE kind as SCHEMA (and conversely) in exp.Create
Pull Request -
State: closed - Opened by georgesittas about 2 months ago
- 2 comments
#3911 - Fix(clickhouse): wrap query in CTAS when COMMENT prop is present
Pull Request -
State: closed - Opened by georgesittas about 2 months ago
#3910 - Fix(clickhouse): COMMENT property in CTAS needs to come last
Pull Request -
State: closed - Opened by georgesittas about 2 months ago
#3909 - Overlapping disjunctions are not optimized
Issue -
State: closed - Opened by rcurtin about 2 months ago
- 5 comments
#3908 - [hive]Multi-insert will error when parse_one
Issue -
State: closed - Opened by hellozepp about 2 months ago
- 1 comment
#3907 - generate_series() is not transpiled when going from postgres to mysql
Issue -
State: closed - Opened by Toms1999 about 2 months ago
- 1 comment
#3906 - Fix: various fixups for unnest(generatedatearray) transpilation
Pull Request -
State: closed - Opened by georgesittas about 2 months ago
#3905 - DATE_PART(ISO_WEEK, {date}) not transpiling correctly from TSQL to Databricks (Spark version >= 3.0).
Issue -
State: closed - Opened by EthanTaft about 2 months ago
- 1 comment
#3904 - Feat(clickhouse): support PARTITION BY, SETTINGS in Insert expression
Pull Request -
State: closed - Opened by georgesittas about 2 months ago
#3902 - chore: New doc - Onboarding Doc
Pull Request -
State: closed - Opened by VaggelisD about 2 months ago
- 4 comments
#3901 - Fix(parser): improve performance of OUTER/CROSS APPLY parsing
Pull Request -
State: closed - Opened by georgesittas about 2 months ago
#3900 - Fix(clickhouse): generate exp.Values correctly, handle `FORMAT Values`
Pull Request -
State: closed - Opened by georgesittas about 2 months ago
#3899 - Feat!: transpile Unnest(GenerateDateArray(...)) to various dialects
Pull Request -
State: closed - Opened by georgesittas about 2 months ago
#3898 - Parsing APPLY doubles execution time per APPLY statement
Issue -
State: closed - Opened by ewhitley about 2 months ago
- 2 comments
#3897 - MOD function is replaced by % in ORACLE. It shouldn't be.
Issue -
State: closed - Opened by Hal-H2Apps about 2 months ago
- 1 comment
#3896 - Support Athena UNLOAD...TO
Issue -
State: closed - Opened by symroe about 2 months ago
- 4 comments
#3895 - Small clickhouse fixes
Pull Request -
State: closed - Opened by jwhitaker-gridcog about 2 months ago
- 4 comments
#3894 - Feat(bigquery): transpile format_datetime, datetime_trunc to duckdb
Pull Request -
State: closed - Opened by skadel about 2 months ago
- 3 comments
#3893 - feat(bigquery): Add FORMAT_DATETIME and DATETIME_TRUNC support to duckdb transpile
Pull Request -
State: closed - Opened by skadel about 2 months ago
#3891 - Fix(snowflake)!: parse v NOT IN (subquery) as v <> ALL (subquery)
Pull Request -
State: closed - Opened by georgesittas about 2 months ago
#3890 - [Snowflake]: Changed place of 'NOT' in 'WHERE' statement
Issue -
State: closed - Opened by ajuszczak about 2 months ago
- 2 comments
#3889 - DuckDB: Optimizer recommends `EXPLODE` function but it does not exist
Issue -
State: closed - Opened by NielsKorschinsky about 2 months ago
- 2 comments
#3888 - feat(bigquery): Support for GENERATE_TIMESTAMP_ARRAY, DDB transpilation
Pull Request -
State: closed - Opened by VaggelisD about 2 months ago
#3887 - fix: Fix COLLATE's RHS parsing
Pull Request -
State: closed - Opened by VaggelisD about 2 months ago
- 1 comment
#3886 - CLUSTERED index is failing
Issue -
State: closed - Opened by stig-2 about 2 months ago
- 1 comment
#3885 - Fix(snowflake): support table qualification in USING clause
Pull Request -
State: closed - Opened by georgesittas about 2 months ago
#3883 - feat(duckdb): Transpile Snowflake's CONVERT_TIMEZONE 3-arg version
Pull Request -
State: closed - Opened by VaggelisD about 2 months ago
- 1 comment
#3882 - DATEPART arguments without quotes (redshift)
Issue -
State: closed - Opened by ArielGonzalezC about 2 months ago
#3881 - Error in parsing of `JOIN ... USING` expressions in Snowflake
Issue -
State: closed - Opened by dlahyani about 2 months ago
- 4 comments
#3880 - T-SQL COLLATE argument being interpreted as a column
Issue -
State: closed - Opened by ewhitley about 2 months ago
#3879 - Refactor(optimizer)!: switch off CSV file schema inference by default
Pull Request -
State: closed - Opened by georgesittas about 2 months ago
#3878 - feat(databricks): Add support for STREAMING tables
Pull Request -
State: closed - Opened by VaggelisD about 2 months ago
- 2 comments
#3877 - Fix(bigquery): ensure Funcs are preserved when used as Tables
Pull Request -
State: closed - Opened by georgesittas about 2 months ago
#3876 - sqlglot does not support databricks SQL streaming syntax
Issue -
State: closed - Opened by ericvergnaud about 2 months ago
- 4 comments
#3875 - transpile from snowflake to duckdb with convert timezone is not working
Issue -
State: closed - Opened by milonimrod about 2 months ago
- 5 comments
#3874 - TSQL Dialect failing with multiple DECLARE statements
Issue -
State: closed - Opened by sumanth-manchala about 2 months ago
- 1 comment
#3873 - feat(parser)!: Support ALTER VIEW AS SELECT
Pull Request -
State: closed - Opened by xiaohui-sun about 2 months ago
- 8 comments
#3872 - Fix!(optimizer): detect correlation in derived tables nested within subqueries
Pull Request -
State: closed - Opened by georgesittas about 2 months ago
#3871 - fix(duckdb): Allow DESCRIBE as a _parse_select() path
Pull Request -
State: closed - Opened by VaggelisD about 2 months ago
- 1 comment
#3870 - fix: Fixed size array parsing
Pull Request -
State: closed - Opened by VaggelisD about 2 months ago
#3869 - selecting from `describe t` using duckdb dialect is incorrect
Issue -
State: closed - Opened by cpcloud about 2 months ago
#3868 - Bug: Cast using array element (Snowflake)
Issue -
State: closed - Opened by tekumara about 2 months ago
#3867 - Feat(snowflake): add support for a a couple of missing clauses in PIVOT clause
Pull Request -
State: closed - Opened by georgesittas 2 months ago
#3866 - Fix(parser): make assignment parsing more lenient by allowing keyword in LHS
Pull Request -
State: closed - Opened by georgesittas 2 months ago
#3865 - feat(duckdb)!: Support for BQ's exp.GenerateDateArray generation
Pull Request -
State: closed - Opened by VaggelisD 2 months ago
#3864 - fix!: Generation of exp.ArrayConcat for 2-arg based dialects
Pull Request -
State: closed - Opened by VaggelisD 2 months ago
- 1 comment
#3863 - feat(teradata): Parse RENAME TABLE as Command
Pull Request -
State: closed - Opened by VaggelisD 2 months ago
#3862 - Duplicate Aliases Don't Have Their Lineage Traced Correctly
Issue -
State: closed - Opened by johnpawleylr 2 months ago
- 3 comments
#3861 - RENAME TABLE not supported on TERADATA dialect
Issue -
State: closed - Opened by EdouardW 2 months ago
#3860 - sqlite to tsql translate same error
Issue -
State: closed - Opened by SophieGarden 2 months ago
- 1 comment
#3859 - fix(clickhouse): Fix SETTINGS parsing
Pull Request -
State: closed - Opened by VaggelisD 2 months ago
#3858 - Fails to parse ClickHouse `CREATE TABLE` sql if both `SETTINGS` and `COMMENT` clauses are specified
Issue -
State: closed - Opened by obazna 2 months ago
#3857 - fix(duckdb): Add implicit casts to DATE_DIFF
Pull Request -
State: closed - Opened by VaggelisD 2 months ago
- 3 comments
#3856 - feat(duckdb): Support for exp.TimeDiff generation
Pull Request -
State: closed - Opened by VaggelisD 2 months ago
- 2 comments
#3855 - Fix(presto): map %W to %A in the TIME_MAPPING
Pull Request -
State: closed - Opened by georgesittas 2 months ago
#3854 - Incorrect format option for DATE_FORMAT when transpiling from Spark to Presto
Issue -
State: closed - Opened by ddelzell 2 months ago
#3853 - Feat!: transpile postgres impliclitly exploding GENERATE_SERIES proje…
Pull Request -
State: closed - Opened by georgesittas 2 months ago