{
  "_id": "6a61ae1af673e46fff56da06",
  "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-07-23 05:52:11 UTC",
    "User": "root"
  },
  "Author": "Martijn Schuemie [aut, cre],\nMarc Suchard [aut]",
  "_user": "ohdsi",
  "_type": "src",
  "_file": "SqlRender_1.19.5.tar.gz",
  "_fileid": "https://r2.ropensci.org/67e5301450371e42af590ffe10fdf1b80a513c981840e68e9d69e42bd58b9c34",
  "_filesize": 609170,
  "_sha256": "67e5301450371e42af590ffe10fdf1b80a513c981840e68e9d69e42bd58b9c34",
  "_expires": "2026-10-31T06:00:56.000Z",
  "_created": "2026-07-23T05:52:11.000Z",
  "_published": "2026-07-23T06:00:58.736Z",
  "_jobs": [
    {
      "job": 89129770204,
      "time": 157,
      "config": "linux-devel-x86_64",
      "r": "4.7.0",
      "check": "WARNING",
      "artifact": "8554077397"
    },
    {
      "job": 89129770226,
      "time": 170,
      "config": "linux-release-x86_64",
      "r": "4.6.1",
      "check": "WARNING",
      "artifact": "8554080846"
    },
    {
      "job": 89129770148,
      "time": 127,
      "config": "macos-oldrel-arm64",
      "r": "4.5.3",
      "check": "WARNING",
      "artifact": "8554096183"
    },
    {
      "job": 89129770197,
      "time": 113,
      "config": "macos-release-arm64",
      "r": "4.6.1",
      "check": "WARNING",
      "artifact": "8554171404"
    },
    {
      "job": 89129307742,
      "time": 196,
      "config": "source",
      "r": "4.6.1",
      "check": "OK",
      "artifact": "8554031930"
    },
    {
      "job": 89129770152,
      "time": 121,
      "config": "wasm-release",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "8554066691"
    },
    {
      "job": 89129770188,
      "time": 105,
      "config": "windows-devel-x86_64",
      "r": "4.7.0",
      "check": "WARNING",
      "artifact": "8554063616"
    },
    {
      "job": 89129770167,
      "time": 109,
      "config": "windows-oldrel-x86_64",
      "r": "4.5.3",
      "check": "WARNING",
      "artifact": "8554064039"
    },
    {
      "job": 89129770193,
      "time": 101,
      "config": "windows-release-x86_64",
      "r": "4.6.1",
      "check": "WARNING",
      "artifact": "8554061660"
    }
  ],
  "_host": "GitHub-Actions",
  "_buildurl": "https://github.com/r-universe/ohdsi/actions/runs/29983173588",
  "_status": "success",
  "_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
  },
  "_distro": "resolute",
  "_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": 18,
  "_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",
    "followers": 1057
  },
  "_downloads": {
    "count": 2897,
    "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": 661,
  "_rbuild": "4.6.1",
  "_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-25-jre-headless",
      "headers": "openjdk-25-jre-headless",
      "source": "openjdk",
      "version": "25.0.3+9-2~26.04.2",
      "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.115430969365963,
  "_indexed": true,
  "_nocasepkg": "sqlrender",
  "_universes": [
    "ohdsi",
    "schuemie"
  ],
  "_binaries": [
    {
      "r": "4.7.0",
      "os": "linux",
      "version": "1.19.5",
      "date": "2026-07-23T05:54:32.000Z",
      "distro": "resolute",
      "commit": "3779e2b962fa6268e0d9bda2c35078a2c5b1634e",
      "fileid": "https://r2.ropensci.org/a4a765a8596303f43ba38c2bcff729f10516f3fdd2627e247c1ec243b4529423",
      "status": "success",
      "check": "WARNING",
      "buildurl": "https://github.com/r-universe/ohdsi/actions/runs/29983173588"
    },
    {
      "r": "4.6.1",
      "os": "linux",
      "version": "1.19.5",
      "date": "2026-07-23T05:54:43.000Z",
      "distro": "resolute",
      "commit": "3779e2b962fa6268e0d9bda2c35078a2c5b1634e",
      "fileid": "https://r2.ropensci.org/826bdcbf662ad648bf690972d586ba3ffd8973e1a716a34d3def91b09caf9d8b",
      "status": "success",
      "check": "WARNING",
      "buildurl": "https://github.com/r-universe/ohdsi/actions/runs/29983173588"
    },
    {
      "r": "4.5.3",
      "os": "mac",
      "version": "1.19.5",
      "date": "2026-07-23T05:55:46.000Z",
      "commit": "3779e2b962fa6268e0d9bda2c35078a2c5b1634e",
      "fileid": "https://r2.ropensci.org/6d34534fc5787018c889e49723231e52a806e9170ed3be188540d4554ecbaaef",
      "status": "success",
      "check": "WARNING",
      "buildurl": "https://github.com/r-universe/ohdsi/actions/runs/29983173588"
    },
    {
      "r": "4.6.1",
      "os": "mac",
      "version": "1.19.5",
      "date": "2026-07-23T06:00:05.000Z",
      "commit": "3779e2b962fa6268e0d9bda2c35078a2c5b1634e",
      "fileid": "https://r2.ropensci.org/73b68b5e4b7b232635d9f606af3f23d2b91d108515b9d6f32847f822dc78f5ce",
      "status": "success",
      "check": "WARNING",
      "buildurl": "https://github.com/r-universe/ohdsi/actions/runs/29983173588"
    },
    {
      "r": "4.6.0",
      "os": "wasm",
      "version": "1.19.5",
      "date": "2026-07-23T05:54:27.000Z",
      "commit": "3779e2b962fa6268e0d9bda2c35078a2c5b1634e",
      "fileid": "https://r2.ropensci.org/3e5518c97ac332731799769e98f96bf71591f2cf92c35197d71a0229fbb8ae3c",
      "status": "success",
      "buildurl": "https://github.com/r-universe/ohdsi/actions/runs/29983173588"
    },
    {
      "r": "4.7.0",
      "os": "win",
      "version": "1.19.5",
      "date": "2026-07-23T05:53:30.000Z",
      "commit": "3779e2b962fa6268e0d9bda2c35078a2c5b1634e",
      "fileid": "https://r2.ropensci.org/2ec5c8dca45424281b78b6d53131f817d84c3b26db97a5622e3c85515f04c144",
      "status": "success",
      "check": "WARNING",
      "buildurl": "https://github.com/r-universe/ohdsi/actions/runs/29983173588"
    },
    {
      "r": "4.5.3",
      "os": "win",
      "version": "1.19.5",
      "date": "2026-07-23T05:53:35.000Z",
      "commit": "3779e2b962fa6268e0d9bda2c35078a2c5b1634e",
      "fileid": "https://r2.ropensci.org/3c3090348cb0369cc806ebc39db6b53d4edf4b33400809529a012af4f728fae0",
      "status": "success",
      "check": "WARNING",
      "buildurl": "https://github.com/r-universe/ohdsi/actions/runs/29983173588"
    },
    {
      "r": "4.6.1",
      "os": "win",
      "version": "1.19.5",
      "date": "2026-07-23T05:53:28.000Z",
      "commit": "3779e2b962fa6268e0d9bda2c35078a2c5b1634e",
      "fileid": "https://r2.ropensci.org/76485521d6b830d9dd986be497d762bab9e18d0143ee7c3ef91549ce3692ff74",
      "status": "success",
      "check": "WARNING",
      "buildurl": "https://github.com/r-universe/ohdsi/actions/runs/29983173588"
    }
  ]
}