OHDSI/SqlRender

View on GitHub

This is an R package and Java library for rendering parameterized SQL, and translating it to different SQL dialects.

Stars: 89
Forks: 87
Open beginner issues: 0
Indexed issues: 14
Avg merge: 19d 1h
Merged PRs (30d): 3

Dominant language: R
License: No license data
Last GitHub push: Sep 18, 2026
Latest indexed: Sep 19, 2026
Contributing guide: No contributing guide
Code of conduct: No code of conduct
Beginner labels: help wanted good first issue

Beginner friendly Everything

Open All

14 open issues indexed

ISNUMERIC translation in sqlite broken Open

Difficulty 3/5 1-2 days Newbie friendliness 48/100

OHDSI/SqlRender#400 · Opened Aug 29, 2026
ISNUMERIC for negative values Open

Difficulty 2/5 1-3 hours Newbie friendliness 72/100

OHDSI/SqlRender#398 · Opened Aug 29, 2026
DATEADD with second/minute/hour drops the datetime argument on Oracle and SQLite Open

Difficulty 2/5 1-3 hours Newbie friendliness 88/100

OHDSI/SqlRender#396 · Opened Aug 28, 2026
Revisit GROUP BY translation for BigQuery Open

Difficulty 3/5 1-2 days Newbie friendliness 58/100

OHDSI/SqlRender#391 · Opened Jun 12, 2026
Better handling of erroneous use of CREATE TABLE AS SELECT Open

Difficulty 5/5 Over a week Newbie friendliness 25/100

OHDSI/SqlRender#388 · Opened Sep 23, 2025
ClickHouse Support Open

Difficulty 4/5 3-5 days Newbie friendliness 25/100

OHDSI/SqlRender#382 · 2 comments · 4 reactions · Opened Feb 4, 2025
unable to take advantage of user-defined temp schema emulation in SQL server dialect Open

Difficulty 5/5 Over a week Newbie friendliness 25/100

OHDSI/SqlRender#380 · Opened Nov 11, 2024
Correct translation of quotes (e.g for `offset` field in `nlp_note`) Open

bug

OHDSI/SqlRender#341 · 10 comments · 1 assignee · Opened Aug 9, 2023
Formally define OHDSI-SQL Open

exploratory

Difficulty 5/5 Over a week Newbie friendliness 25/100

OHDSI/SqlRender#290 · 4 comments · Opened Aug 5, 2022
Sunset PDW support Open

exploratory help wanted

Difficulty 4/5 3-5 days Newbie friendliness 35/100

OHDSI/SqlRender#272 · 1 reaction · Opened Jan 5, 2022
old syntax used in "drop index" Open

enhancement help wanted

Difficulty 3/5 1-2 days Newbie friendliness 35/100

OHDSI/SqlRender#267 · 3 comments · Opened Oct 5, 2021
Bigquery: GROUP BY error Open

bug help wanted

Difficulty 4/5 3-5 days Newbie friendliness 20/100

OHDSI/SqlRender#249 · 9 comments · 1 reaction · Opened Apr 18, 2021
Postgres [ character not supported Open

bug

Difficulty 3/5 1-2 days Newbie friendliness 42/100

OHDSI/SqlRender#170 · Opened Mar 15, 2019
Create OhdsiSql reference? Open

documentation good first issue help wanted

Difficulty 5/5 Over a week Newbie friendliness 35/100

OHDSI/SqlRender#157 · 1 comment · Opened Feb 11, 2019

OHDSI/SqlRender

Get new issues in your inbox