{
  "_id": "6a12a8feacfb0bcc41d1580c",
  "Package": "SqlRender",
  "Type": "Package",
  "Title": "Rendering Parameterized SQL and Translation to Dialects",
  "Version": "1.19.5",
  "Date": "2026-03-24",
  "Authors@R": "c(\nperson(\"Martijn\", \"Schuemie\", , \"schuemie@ohdsi.org\", role = c(\"aut\", \"cre\")),\nperson(\"Marc\", \"Suchard\", role = c(\"aut\"))\n)",
  "Maintainer": "Martijn Schuemie <schuemie@ohdsi.org>",
  "Description": "A rendering tool for parameterized SQL that also\ntranslates into different SQL dialects.  These dialects include\n'Microsoft SQL Server', 'Oracle', 'PostgreSql', 'Amazon\nRedShift', 'Apache Impala', 'IBM Netezza', 'Google BigQuery',\n'Microsoft PDW', 'Snowflake', 'Azure Synapse Analytics\nDedicated', 'Apache Spark', 'SQLite', and 'InterSystems IRIS'.",
  "SystemRequirements": "Java (>= 8)",
  "License": "Apache License 2.0",
  "VignetteBuilder": "knitr",
  "URL": "https://ohdsi.github.io/SqlRender/,\nhttps://github.com/OHDSI/SqlRender",
  "BugReports": "https://github.com/OHDSI/SqlRender/issues",
  "RoxygenNote": "7.3.3",
  "Encoding": "UTF-8",
  "Config/pak/sysreqs": "make default-jdk",
  "Repository": "https://ohdsi.r-universe.dev",
  "Date/Publication": "2026-03-25 11:25:00 UTC",
  "RemoteUrl": "https://github.com/ohdsi/sqlrender",
  "RemoteRef": "HEAD",
  "RemoteSha": "3779e2b962fa6268e0d9bda2c35078a2c5b1634e",
  "NeedsCompilation": "no",
  "Packaged": {
    "Date": "2026-05-24 07:23:56 UTC",
    "User": "root"
  },
  "Author": "Martijn Schuemie [aut, cre],\nMarc Suchard [aut]",
  "MD5sum": "680830652c00dd2aeb53cf7f7bb25962",
  "_user": "ohdsi",
  "_type": "src",
  "_file": "SqlRender_1.19.5.tar.gz",
  "_fileid": "0028e205022286d227fc2e613d74bbaa11fa27d6434c31244e02d4e1fa718c3a",
  "_filesize": 608172,
  "_sha256": "0028e205022286d227fc2e613d74bbaa11fa27d6434c31244e02d4e1fa718c3a",
  "_created": "2026-05-24T07:23:56.000Z",
  "_published": "2026-05-24T07:30:06.811Z",
  "_distro": "noble",
  "_jobs": [
    {
      "job": 77580235167,
      "time": 146,
      "config": "linux-devel-x86_64",
      "r": "4.7.0",
      "check": "WARNING",
      "artifact": "7183251083"
    },
    {
      "job": 77580235171,
      "time": 144,
      "config": "linux-release-x86_64",
      "r": "4.6.0",
      "check": "WARNING",
      "artifact": "7183250828"
    },
    {
      "job": 77580235172,
      "time": 131,
      "config": "macos-oldrel-arm64",
      "r": "4.5.3",
      "check": "WARNING",
      "artifact": "7183270484"
    },
    {
      "job": 77580235166,
      "time": 110,
      "config": "macos-release-arm64",
      "r": "4.6.0",
      "check": "WARNING",
      "artifact": "7183269107"
    },
    {
      "job": 77580073679,
      "time": 182,
      "config": "source",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "7183234935"
    },
    {
      "job": 77580235161,
      "time": 110,
      "config": "wasm-release",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "7183247221"
    },
    {
      "job": 77580235179,
      "time": 86,
      "config": "windows-devel",
      "r": "4.7.0",
      "check": "WARNING",
      "artifact": "7183244681"
    },
    {
      "job": 77580235176,
      "time": 118,
      "config": "windows-oldrel",
      "r": "4.5.3",
      "check": "WARNING",
      "artifact": "7183248026"
    },
    {
      "job": 77580235181,
      "time": 92,
      "config": "windows-release",
      "r": "4.6.0",
      "check": "WARNING",
      "artifact": "7183246109"
    }
  ],
  "_buildurl": "https://github.com/r-universe/ohdsi/actions/runs/26355011484",
  "_status": "success",
  "_host": "GitHub-Actions",
  "_upstream": "https://github.com/ohdsi/sqlrender",
  "_commit": {
    "id": "3779e2b962fa6268e0d9bda2c35078a2c5b1634e",
    "author": "schuemie <schuemie@ohdsi.org>",
    "committer": "schuemie <schuemie@ohdsi.org>",
    "message": "Updating CRAN-SUBMISSION\n",
    "time": 1774437900
  },
  "_maintainer": {
    "name": "Martijn Schuemie",
    "email": "schuemie@ohdsi.org",
    "login": "schuemie",
    "description": "",
    "uuid": 6713328
  },
  "_registered": true,
  "_dependencies": [
    {
      "package": "rJava",
      "role": "Imports"
    },
    {
      "package": "rlang",
      "role": "Imports"
    },
    {
      "package": "checkmate",
      "role": "Imports"
    },
    {
      "package": "testthat",
      "role": "Suggests"
    },
    {
      "package": "knitr",
      "role": "Suggests"
    },
    {
      "package": "rmarkdown",
      "role": "Suggests"
    },
    {
      "package": "shiny",
      "role": "Suggests"
    },
    {
      "package": "shinydashboard",
      "role": "Suggests"
    }
  ],
  "_owner": "ohdsi",
  "_selfowned": true,
  "_usedby": 17,
  "_updates": [
    {
      "week": "2025-33",
      "n": 1
    },
    {
      "week": "2025-34",
      "n": 2
    },
    {
      "week": "2025-39",
      "n": 3
    },
    {
      "week": "2025-42",
      "n": 1
    },
    {
      "week": "2026-13",
      "n": 2
    }
  ],
  "_tags": [
    {
      "name": "v1.19.3",
      "date": "2025-08-19"
    },
    {
      "name": "v1.19.4",
      "date": "2025-09-27"
    },
    {
      "name": "v1.19.5",
      "date": "2026-03-25"
    }
  ],
  "_topics": [
    "hades",
    "openjdk"
  ],
  "_stars": 87,
  "_contributors": [
    {
      "user": "schuemie",
      "count": 437,
      "uuid": 6713328
    },
    {
      "user": "msuchard",
      "count": 52,
      "uuid": 149039
    },
    {
      "user": "wivern",
      "count": 46,
      "uuid": 1109753
    },
    {
      "user": "pavgra",
      "count": 32,
      "uuid": 10010071
    },
    {
      "user": "ssuvorov-fls",
      "count": 26,
      "uuid": 46920469
    },
    {
      "user": "bdeboe",
      "count": 22,
      "uuid": 12095468
    },
    {
      "user": "tomwhite-medstar",
      "count": 11,
      "uuid": 75700951
    },
    {
      "user": "myounglai",
      "count": 10,
      "uuid": 26904261
    },
    {
      "user": "aklochkova",
      "count": 9,
      "uuid": 38942654
    },
    {
      "user": "anthonysena",
      "count": 9,
      "uuid": 12902366
    },
    {
      "user": "tsemharb",
      "count": 8,
      "uuid": 28675893
    },
    {
      "user": "alondhe",
      "count": 7,
      "uuid": 8037742
    },
    {
      "user": "alexfranken",
      "count": 6,
      "uuid": 5394963
    },
    {
      "user": "chrisknoll",
      "count": 6,
      "uuid": 6818777
    },
    {
      "user": "tomwhite",
      "count": 6,
      "uuid": 85085
    },
    {
      "user": "javier-gracia-tabuenca-tuni",
      "count": 3,
      "uuid": 54809193
    },
    {
      "user": "egillax",
      "count": 3,
      "uuid": 24678081
    },
    {
      "user": "alibell",
      "count": 2,
      "uuid": 13646493
    },
    {
      "user": "andreyyiv",
      "count": 2,
      "uuid": 6529394
    },
    {
      "user": "agackovka",
      "count": 2,
      "uuid": 4963106
    },
    {
      "user": "gowthamrao",
      "count": 2,
      "uuid": 13936600
    },
    {
      "user": "azimov",
      "count": 2,
      "uuid": 180659
    },
    {
      "user": "anton-abushkevich",
      "count": 1,
      "uuid": 765539
    },
    {
      "user": "fdefalco",
      "count": 1,
      "uuid": 6586384
    },
    {
      "user": "ganisimov",
      "count": 1,
      "uuid": 18571443
    },
    {
      "user": "jlleitschuh",
      "count": 1,
      "uuid": 1323708
    },
    {
      "user": "maximmoinat",
      "count": 1,
      "uuid": 17825660
    },
    {
      "user": "thecedarprince",
      "count": 1,
      "uuid": 29561456
    },
    {
      "user": "troels",
      "count": 1,
      "uuid": 3203
    },
    {
      "user": "alex-odysseus",
      "count": 1,
      "uuid": 75131044
    }
  ],
  "_userbio": {
    "uuid": 6570077,
    "type": "organization",
    "name": "Observational Health Data Sciences and Informatics"
  },
  "_downloads": {
    "count": 3565,
    "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/SqlRender"
  },
  "_mentions": 2,
  "_devurl": "https://github.com/ohdsi/sqlrender",
  "_pkgdown": "https://ohdsi.github.io/SqlRender/",
  "_searchresults": 491,
  "_rbuild": "4.6.0",
  "_assets": [
    "extra/citation.cff",
    "extra/citation.html",
    "extra/citation.json",
    "extra/citation.txt",
    "extra/contents.json",
    "extra/NEWS.html",
    "extra/NEWS.txt",
    "extra/readme.html",
    "extra/readme.md",
    "extra/SqlRender.html",
    "manual.pdf"
  ],
  "_homeurl": "https://github.com/ohdsi/sqlrender",
  "_realowner": "ohdsi",
  "_cranurl": true,
  "_releases": [
    {
      "version": "1.1.7",
      "date": "2016-08-16"
    },
    {
      "version": "1.2.0",
      "date": "2017-01-16"
    },
    {
      "version": "1.3.0",
      "date": "2017-03-24"
    },
    {
      "version": "1.3.7",
      "date": "2017-05-03"
    },
    {
      "version": "1.4.3",
      "date": "2017-09-15"
    },
    {
      "version": "1.4.6",
      "date": "2017-11-07"
    },
    {
      "version": "1.4.8",
      "date": "2018-02-26"
    },
    {
      "version": "1.5.0",
      "date": "2018-05-28"
    },
    {
      "version": "1.5.2",
      "date": "2018-08-17"
    },
    {
      "version": "1.5.3",
      "date": "2018-11-23"
    },
    {
      "version": "1.6.0",
      "date": "2019-02-15"
    },
    {
      "version": "1.6.2",
      "date": "2019-06-24"
    },
    {
      "version": "1.6.3",
      "date": "2020-01-13"
    },
    {
      "version": "1.6.4",
      "date": "2020-03-17"
    },
    {
      "version": "1.6.5",
      "date": "2020-04-01"
    },
    {
      "version": "1.6.6",
      "date": "2020-05-19"
    },
    {
      "version": "1.6.8",
      "date": "2020-07-31"
    },
    {
      "version": "1.7.0",
      "date": "2021-03-02"
    },
    {
      "version": "1.8.0",
      "date": "2021-09-02"
    },
    {
      "version": "1.8.1",
      "date": "2021-09-15"
    },
    {
      "version": "1.8.3",
      "date": "2022-01-07"
    },
    {
      "version": "1.9.0",
      "date": "2022-02-18"
    },
    {
      "version": "1.9.1",
      "date": "2022-06-29"
    },
    {
      "version": "1.9.2",
      "date": "2022-07-11"
    },
    {
      "version": "1.10.0",
      "date": "2022-09-20"
    },
    {
      "version": "1.11.0",
      "date": "2022-12-02"
    },
    {
      "version": "1.11.1",
      "date": "2023-01-14"
    },
    {
      "version": "1.12.0",
      "date": "2023-01-26"
    },
    {
      "version": "1.12.1",
      "date": "2023-02-21"
    },
    {
      "version": "1.13.0",
      "date": "2023-03-14"
    },
    {
      "version": "1.13.1",
      "date": "2023-03-21"
    },
    {
      "version": "1.14.0",
      "date": "2023-04-13"
    },
    {
      "version": "1.15.0",
      "date": "2023-05-08"
    },
    {
      "version": "1.15.1",
      "date": "2023-06-29"
    },
    {
      "version": "1.15.2",
      "date": "2023-08-10"
    },
    {
      "version": "1.16.0",
      "date": "2023-09-20"
    },
    {
      "version": "1.16.1",
      "date": "2023-10-07"
    },
    {
      "version": "1.17.0",
      "date": "2024-03-20"
    },
    {
      "version": "1.18.0",
      "date": "2024-05-30"
    },
    {
      "version": "1.18.1",
      "date": "2024-08-21"
    },
    {
      "version": "1.19.0",
      "date": "2024-10-09"
    },
    {
      "version": "1.19.1",
      "date": "2024-11-29"
    },
    {
      "version": "1.19.2",
      "date": "2025-03-13"
    },
    {
      "version": "1.19.3",
      "date": "2025-08-19"
    },
    {
      "version": "1.19.4",
      "date": "2025-09-26"
    },
    {
      "version": "1.19.5",
      "date": "2026-03-25"
    }
  ],
  "_exports": [
    "camelCaseToSnakeCase",
    "camelCaseToSnakeCaseNames",
    "camelCaseToTitleCase",
    "createRWrapperForSql",
    "getTempTablePrefix",
    "launchSqlRenderDeveloper",
    "listSupportedDialects",
    "loadRenderTranslateSql",
    "readSql",
    "render",
    "renderSql",
    "renderSqlFile",
    "snakeCaseToCamelCase",
    "snakeCaseToCamelCaseNames",
    "sparkHandleInsert",
    "splitSql",
    "supportsJava8",
    "translate",
    "translateSingleStatement",
    "translateSql",
    "translateSqlFile",
    "writeSql"
  ],
  "_help": [
    {
      "page": "camelCaseToSnakeCase",
      "title": "Convert a camel case string to snake case",
      "topics": [
        "camelCaseToSnakeCase"
      ]
    },
    {
      "page": "camelCaseToSnakeCaseNames",
      "title": "Convert the names of an object from camel case to snake case",
      "topics": [
        "camelCaseToSnakeCaseNames"
      ]
    },
    {
      "page": "camelCaseToTitleCase",
      "title": "Convert a camel case string to title case",
      "topics": [
        "camelCaseToTitleCase"
      ]
    },
    {
      "page": "createRWrapperForSql",
      "title": "Create an R wrapper for SQL",
      "topics": [
        "createRWrapperForSql"
      ]
    },
    {
      "page": "getTempTablePrefix",
      "title": "Get the prefix used for emulated temp tables for DBMSs that do not support temp tables (e.g. Oracle, BigQuery).",
      "topics": [
        "getTempTablePrefix"
      ]
    },
    {
      "page": "launchSqlRenderDeveloper",
      "title": "Launch the SqlRender Developer Shiny app",
      "topics": [
        "launchSqlRenderDeveloper"
      ]
    },
    {
      "page": "listSupportedDialects",
      "title": "List the supported target dialects",
      "topics": [
        "listSupportedDialects"
      ]
    },
    {
      "page": "loadRenderTranslateSql",
      "title": "Load, render, and translate a SQL file in a package",
      "topics": [
        "loadRenderTranslateSql"
      ]
    },
    {
      "page": "readSql",
      "title": "Reads a SQL file",
      "topics": [
        "readSql"
      ]
    },
    {
      "page": "render",
      "title": "Render SQL code based on parameterized SQL and parameter values",
      "topics": [
        "render"
      ]
    },
    {
      "page": "renderSql",
      "title": "Deprecated: Render SQL code based on parameterized SQL and parameter values",
      "topics": [
        "renderSql"
      ]
    },
    {
      "page": "renderSqlFile",
      "title": "Render a SQL file",
      "topics": [
        "renderSqlFile"
      ]
    },
    {
      "page": "snakeCaseToCamelCase",
      "title": "Convert a snake case string to camel case",
      "topics": [
        "snakeCaseToCamelCase"
      ]
    },
    {
      "page": "snakeCaseToCamelCaseNames",
      "title": "Convert the names of an object from snake case to camel case",
      "topics": [
        "snakeCaseToCamelCaseNames"
      ]
    },
    {
      "page": "sparkHandleInsert",
      "title": "Handles Spark Inserts",
      "topics": [
        "sparkHandleInsert"
      ]
    },
    {
      "page": "splitSql",
      "title": "Split a single SQL string into one or more SQL statements",
      "topics": [
        "splitSql"
      ]
    },
    {
      "page": "supportsJava8",
      "title": "Determine if Java virtual machine supports Java",
      "topics": [
        "supportsJava8"
      ]
    },
    {
      "page": "translate",
      "title": "Translates SQL from one dialect to another",
      "topics": [
        "translate"
      ]
    },
    {
      "page": "translateSingleStatement",
      "title": "Translates a single SQL statement from one dialect to another",
      "topics": [
        "translateSingleStatement"
      ]
    },
    {
      "page": "translateSql",
      "title": "Deprecated: Translates SQL from one dialect to another",
      "topics": [
        "translateSql"
      ]
    },
    {
      "page": "translateSqlFile",
      "title": "Translate a SQL file",
      "topics": [
        "translateSqlFile"
      ]
    },
    {
      "page": "writeSql",
      "title": "Write SQL to a SQL (text) file",
      "topics": [
        "writeSql"
      ]
    }
  ],
  "_readme": "https://github.com/ohdsi/sqlrender/raw/HEAD/README.md",
  "_rundeps": [
    "backports",
    "checkmate",
    "rJava",
    "rlang"
  ],
  "_sysdeps": [
    {
      "shlib": "libjvm",
      "package": "openjdk-21-jre-headless",
      "headers": "openjdk-21-jre-headless",
      "source": "openjdk",
      "version": "21.0.10+7-1~24.04",
      "name": "openjdk",
      "homepage": "https://openjdk.java.net/",
      "description": "OpenJDK Java runtime, using Hotspot JIT (headless)"
    }
  ],
  "_vignettes": [
    {
      "source": "UsingSqlRender.Rmd",
      "filename": "UsingSqlRender.html",
      "title": "Using SqlRender",
      "author": "Martijn J. Schuemie",
      "engine": "knitr::rmarkdown",
      "headings": [
        "Introduction",
        "SQL parameterization",
        "Substituting parameter values",
        "Default parameter values",
        "If-then-else",
        "Translation to other SQL dialects",
        "Functions and structures supported by translate",
        "String concatenation",
        "Bitwise operators",
        "Table aliases and the AS keyword",
        "Temp tables",
        "Implicit casts",
        "Case sensitivity in string comparisons",
        "Schemas and databases",
        "Optimization for massively parallel processing",
        "Debugging parameterized SQL",
        "Developing R packages that contain parameterized SQL",
        "Spark SQL"
      ],
      "created": "2014-11-28 09:10:19",
      "modified": "2024-09-30 06:12:13",
      "commits": 45
    }
  ],
  "_score": 12.051598457262383,
  "_indexed": true,
  "_nocasepkg": "sqlrender",
  "_universes": [
    "ohdsi",
    "schuemie"
  ],
  "_binaries": [
    {
      "r": "4.7.0",
      "os": "linux",
      "version": "1.19.5",
      "date": "2026-05-24T07:26:09.000Z",
      "distro": "noble",
      "commit": "3779e2b962fa6268e0d9bda2c35078a2c5b1634e",
      "fileid": "22b19db6b287edddb0e787a1be0a893cc3f3ee87846c97fa2826c62dd159db41",
      "status": "success",
      "check": "WARNING",
      "buildurl": "https://github.com/r-universe/ohdsi/actions/runs/26355011484"
    },
    {
      "r": "4.6.0",
      "os": "linux",
      "version": "1.19.5",
      "date": "2026-05-24T07:26:08.000Z",
      "distro": "noble",
      "commit": "3779e2b962fa6268e0d9bda2c35078a2c5b1634e",
      "fileid": "4850cddea40eea0293c61cee0c9e0ec83dcd1457e8fd543ae374392bae932919",
      "status": "success",
      "check": "WARNING",
      "buildurl": "https://github.com/r-universe/ohdsi/actions/runs/26355011484"
    },
    {
      "r": "4.5.3",
      "os": "mac",
      "version": "1.19.5",
      "date": "2026-05-24T07:29:23.000Z",
      "commit": "3779e2b962fa6268e0d9bda2c35078a2c5b1634e",
      "fileid": "b2e639669037397bde90ef03150e2c48d325c50810acddc9d95d3676d325d4c8",
      "status": "success",
      "check": "WARNING",
      "buildurl": "https://github.com/r-universe/ohdsi/actions/runs/26355011484"
    },
    {
      "r": "4.6.0",
      "os": "mac",
      "version": "1.19.5",
      "date": "2026-05-24T07:29:11.000Z",
      "commit": "3779e2b962fa6268e0d9bda2c35078a2c5b1634e",
      "fileid": "d4d765a8f71bcba2f49ea362386681a361868027fd52e0648b2a142acd822d98",
      "status": "success",
      "check": "WARNING",
      "buildurl": "https://github.com/r-universe/ohdsi/actions/runs/26355011484"
    },
    {
      "r": "4.6.0",
      "os": "wasm",
      "version": "1.19.5",
      "date": "2026-05-24T07:26:03.000Z",
      "commit": "3779e2b962fa6268e0d9bda2c35078a2c5b1634e",
      "fileid": "734d7c5501f96ccb531f951f795a529e1f64a6958a29fca892cd91e999957f32",
      "status": "success",
      "buildurl": "https://github.com/r-universe/ohdsi/actions/runs/26355011484"
    },
    {
      "r": "4.7.0",
      "os": "win",
      "version": "1.19.5",
      "date": "2026-05-24T07:25:07.000Z",
      "commit": "3779e2b962fa6268e0d9bda2c35078a2c5b1634e",
      "fileid": "9b4fa26e0c49e7c9d66134742ce962d6cbf36325cb9041f3ea7ee1d38e39c1fb",
      "status": "success",
      "check": "WARNING",
      "buildurl": "https://github.com/r-universe/ohdsi/actions/runs/26355011484"
    },
    {
      "r": "4.5.3",
      "os": "win",
      "version": "1.19.5",
      "date": "2026-05-24T07:25:13.000Z",
      "commit": "3779e2b962fa6268e0d9bda2c35078a2c5b1634e",
      "fileid": "d07ad8b8f06c07353d714f24085ea961263ce1f439e6a7465f70973711e1a39d",
      "status": "success",
      "check": "WARNING",
      "buildurl": "https://github.com/r-universe/ohdsi/actions/runs/26355011484"
    },
    {
      "r": "4.6.0",
      "os": "win",
      "version": "1.19.5",
      "date": "2026-05-24T07:25:13.000Z",
      "commit": "3779e2b962fa6268e0d9bda2c35078a2c5b1634e",
      "fileid": "5c78ad673933e809100b1f24ababf67ff7a70c2c58944b9c2db79994bfec1039",
      "status": "success",
      "check": "WARNING",
      "buildurl": "https://github.com/r-universe/ohdsi/actions/runs/26355011484"
    }
  ]
}