Ecosyste.ms: Issues

An open API service for providing issue and pull request metadata for open source projects.

GitHub / OHDSI/SqlRender issues and pull requests

#379 - Additional rewrite rules for InterSystems IRIS

Pull Request - State: closed - Opened by bdeboe about 2 months ago - 5 comments

#377 - Add support for InterSystems IRIS as an additional database platform

Pull Request - State: closed - Opened by bdeboe 2 months ago - 6 comments

#376 - DATEADD in Databricks/Spark failing

Issue - State: closed - Opened by kzollove 3 months ago - 7 comments

#375 - Bump actions/download-artifact from 2 to 4.1.7 in /.github/workflows

Pull Request - State: closed - Opened by dependabot[bot] 3 months ago
Labels: dependencies

#374 - Convert permanent table references to temp table ones

Issue - State: closed - Opened by dmitrys-odysseus 4 months ago - 6 comments

#373 - CAST(@a AS DATE) handling for Snowflake - fixes #372

Pull Request - State: closed - Opened by anthonysena 4 months ago

#372 - Snowflake `CAST(@a AS DATE)`

Issue - State: closed - Opened by anthonysena 4 months ago

#371 - Add translation for DataBricks `CAST(@a AS DATE)`

Pull Request - State: closed - Opened by anthonysena 4 months ago - 1 comment

#370 - DataBricks `CAST(@a AS DATE)` fails

Issue - State: closed - Opened by anthonysena 4 months ago

#369 - Error on duckdb when a function is passed as argument to CAST AS DATE

Issue - State: closed - Opened by katy-sadowski 5 months ago - 4 comments

#368 - fix duckdb adding years + test

Pull Request - State: closed - Opened by egillax 5 months ago - 1 comment

#366 - DATEADD SQL translation possibly incorrect for Databricks/Spark

Issue - State: closed - Opened by ablack3 6 months ago - 13 comments

#365 - HINTs are not translated?

Issue - State: closed - Opened by gowthamrao 6 months ago - 2 comments

#364 - translate function crashing R

Issue - State: open - Opened by antonbarchuk 7 months ago - 6 comments

#363 - Fix #362

Pull Request - State: closed - Opened by TomWhite-MedStar 7 months ago

#359 - listSupportedDialects() function

Issue - State: open - Opened by pharmlovex 10 months ago - 2 comments

#358 - add duckdb NEWID() mapping and a test

Pull Request - State: closed - Opened by egillax 10 months ago

#357 - duckdb NEWID() is translated wrong

Issue - State: open - Opened by egillax 10 months ago

#356 - Handle ADD COLUMN with DEFAULT for spark dialect

Pull Request - State: closed - Opened by ganisimov 11 months ago

#355 - Fixes replacement patters for spark and sqlite

Pull Request - State: closed - Opened by MaximMoinat 11 months ago

#353 - [SECURITY] Use HTTPS to resolve dependencies in Maven Build

Pull Request - State: closed - Opened by JLLeitschuh 12 months ago

#352 - Possible heavy recursion?

Issue - State: open - Opened by schuemie 12 months ago - 3 comments

#351 - Invalid sqlite date rendering CAST AS DATE, DATEDIFF and DATEADD

Issue - State: open - Opened by MaximMoinat about 1 year ago - 1 comment

#350 - cannot install: reference to i386 java in sqlRender?

Issue - State: closed - Opened by MPagel about 1 year ago - 1 comment

#346 - Install hangs on Databricks DBR 13.0 and higher

Issue - State: closed - Opened by danielsparing about 1 year ago - 3 comments

#345 - Feature request: Add support for datetime calculations

Issue - State: open - Opened by TomWhite-MedStar about 1 year ago - 5 comments
Labels: enhancement

#344 - Remove delete/insert translation rules for Databricks

Pull Request - State: closed - Opened by anthonysena about 1 year ago - 1 comment

#342 - With synapse as target, IIF() is not translated resulting in SQL error

Issue - State: closed - Opened by pasirikala over 1 year ago - 1 comment

#341 - Correct translation of quotes (e.g for `offset` field in `nlp_note`)

Issue - State: open - Opened by ablack3 over 1 year ago - 10 comments
Labels: bug

#340 - date add syntax used in Circe produces error with duckdb

Issue - State: closed - Opened by ablack3 over 1 year ago - 5 comments

#339 - MariaDB Syntax

Issue - State: closed - Opened by abbynewbury over 1 year ago - 1 comment

#338 - Update replacementPatterns.csv

Pull Request - State: closed - Opened by javier-gracia-tabuenca-tuni over 1 year ago - 2 comments

#336 - SqlRender fails in Spark for Heracles #200

Issue - State: closed - Opened by TomWhite-MedStar over 1 year ago - 2 comments
Labels: bug

#335 - Standardize build tooling and common libs

Issue - State: closed - Opened by ecruz165 over 1 year ago

#334 - Updated maven libraries to use latest versions of libraries.

Pull Request - State: closed - Opened by ecruz165 over 1 year ago - 1 comment

#333 - Postgresql column rename needs translation with TYPE keyword

Issue - State: closed - Opened by azimov over 1 year ago

#332 - Postgresql translate ALTER COLUMN TYPE

Pull Request - State: closed - Opened by azimov over 1 year ago - 1 comment

#331 - Snowflake `ceiling()`

Pull Request - State: closed - Opened by Tsemharb over 1 year ago - 2 comments

#330 - SqlRender change broke Atlas Characterizations on Spark (DataBricks)

Issue - State: closed - Opened by TomWhite-MedStar over 1 year ago - 7 comments

#329 - Add `Ceiling()` Function to replacement patterns in Snowflake

Issue - State: closed - Opened by Tsemharb over 1 year ago - 1 comment

#328 - adding ceiling() to snowflake

Pull Request - State: closed - Opened by Tsemharb over 1 year ago - 1 comment

#327 - Problematic `TO_DATE` using Oracle

Issue - State: closed - Opened by tlecarrour-ee over 1 year ago - 2 comments

#326 - `missing right parenthesis` on Oracle 19

Issue - State: closed - Opened by tlecarrour-ee over 1 year ago - 2 comments

#325 - Adding missed "drop table" statements for Netezza

Pull Request - State: closed - Opened by ssuvorov-fls over 1 year ago - 3 comments

#324 - added charindex translation for bq

Pull Request - State: closed - Opened by javier-gracia-tabuenca-tuni over 1 year ago - 1 comment

#321 - RAND() works differently in SQL Server and SQLite

Issue - State: closed - Opened by SulevR almost 2 years ago - 2 comments

#320 - Fixes reordering of columns during insert for spark

Pull Request - State: closed - Opened by ssuvorov-fls almost 2 years ago - 1 comment

#319 - Replacement for float keyword for snowflake was removed

Pull Request - State: closed - Opened by ssuvorov-fls almost 2 years ago - 4 comments

#318 - Translate WITH INSERT into INSERT WITH for Snowflake

Pull Request - State: closed - Opened by troels almost 2 years ago

#317 - Rewrite of WITH ... INSERT for Snowflake

Issue - State: closed - Opened by troels almost 2 years ago - 2 comments

#316 - Oracle: BIGINT to NUMBER(38) rather than NUMBER(19)

Issue - State: closed - Opened by donny-son almost 2 years ago - 2 comments
Labels: question

#315 - Redshift isnumeric

Issue - State: closed - Opened by alondhe almost 2 years ago - 5 comments

#314 - Drop all support for Spark

Issue - State: closed - Opened by schuemie almost 2 years ago - 5 comments
Labels: enhancement

#313 - BigQuery: problem with space in column name

Issue - State: closed - Opened by pjlammertyn almost 2 years ago - 3 comments

#312 - Bigquery: multiple counts in select error

Issue - State: closed - Opened by pjlammertyn almost 2 years ago - 2 comments

#311 - v1.11.0 release indicates "v1.10.0-SNAPSHOT" in pom.xml

Issue - State: closed - Opened by konstjar almost 2 years ago - 1 comment

#310 - Bigquery: "intersect" not correctly converted

Issue - State: closed - Opened by pjlammertyn almost 2 years ago - 4 comments
Labels: bug

#309 - Bigquery: Parameterized types are not allowed in CAST expressions.

Issue - State: closed - Opened by pjlammertyn almost 2 years ago - 3 comments

#308 - Spark identifier quotation

Issue - State: closed - Opened by MaximMoinat about 2 years ago - 2 comments

#307 - SELECT INTO with 2 CTEs causes translation failure on Spark

Issue - State: closed - Opened by schuemie about 2 years ago - 2 comments
Labels: bug

#306 - Support for `DROP TABLE IF EXISTS` on `SqlServer`

Issue - State: closed - Opened by azimov about 2 years ago - 1 comment

#305 - Spark CTAS pattern

Issue - State: closed - Opened by alondhe about 2 years ago - 1 comment
Labels: bug

#304 - INSERT INTO translated to CREATE TABLE

Issue - State: closed - Opened by MaximMoinat about 2 years ago - 5 comments
Labels: bug

#303 - Postgresql "a space" not supported.

Issue - State: closed - Opened by yongyonglee about 2 years ago - 3 comments

#302 - added NEWID traslation for BigQuery

Pull Request - State: closed - Opened by javier-gracia-tabuenca-tuni about 2 years ago

#300 - SqlRender documentation question on Translation to other SQL dialects

Issue - State: closed - Opened by solmazeradat about 2 years ago - 2 comments
Labels: question

#299 - replacementPatterns.csv validation test

Pull Request - State: closed - Opened by Tsemharb over 2 years ago - 2 comments

#298 - Incorrect translation caused by missing quotes in replacementPatterns.csv

Issue - State: closed - Opened by Tsemharb over 2 years ago - 1 comment
Labels: bug

#297 - Azure Synapse Analytics Dedicated dialect support

Pull Request - State: closed - Opened by alex-odysseus over 2 years ago - 1 comment

#296 - Azure Synapse Analytics Dedicated dialect support

Issue - State: closed - Opened by alex-odysseus over 2 years ago
Labels: enhancement

#295 - Snowflake dialect support

Pull Request - State: closed - Opened by alex-odysseus over 2 years ago

#294 - Snowflake dialect support

Issue - State: closed - Opened by alex-odysseus over 2 years ago
Labels: enhancement

#292 - Duck db support

Pull Request - State: closed - Opened by Tsemharb over 2 years ago - 2 comments

#291 - loadRenderTranslateSql causes problems with devtools::test()

Issue - State: closed - Opened by ablack3 over 2 years ago - 1 comment
Labels: duplicate

#290 - Formally define OHDSI-SQL

Issue - State: open - Opened by ablack3 over 2 years ago - 4 comments
Labels: exploratory

#289 - Adding new Spark replacementPatterns for INSERT INTO and DELETE

Pull Request - State: closed - Opened by alibell over 2 years ago - 1 comment

#288 - Fix #287: Remove # in temp table names on Redshift

Pull Request - State: closed - Opened by ablack3 over 2 years ago

#287 - temp table names on Redshift may or may not start with #

Issue - State: closed - Opened by ablack3 over 2 years ago - 2 comments

#286 - Add duckdb support

Issue - State: closed - Opened by ablack3 over 2 years ago - 5 comments
Labels: enhancement

#285 - Added small note in README about R v4

Pull Request - State: closed - Opened by TheCedarPrince over 2 years ago

#284 - Icons outdated for shiny app

Issue - State: closed - Opened by SevKohler over 2 years ago - 2 comments
Labels: bug

#283 - Java import does not work with modern mvn versions

Issue - State: closed - Opened by SevKohler over 2 years ago - 4 comments
Labels: bug, help wanted

#282 - checkmate in Imports

Issue - State: closed - Opened by jreps over 2 years ago

#281 - checkmate dependency issue

Issue - State: closed - Opened by jreps over 2 years ago - 1 comment
Labels: duplicate