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

#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

#3935 - Fix(oracle)!: preserve SYSDATE

Pull Request - State: closed - Opened by georgesittas about 1 month ago

#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

#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

#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

#3920 - Fix(clickhouse): add timestamptz type mapping

Pull Request - State: closed - Opened by treysp 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

#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

#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

#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

#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

#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

#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

#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