{
  "_id": "6aad69ec3d719c1f84076fa7",
  "Package": "SqlRender",
  "Type": "Package",
  "Title": "Rendering Parameterized SQL and Translation to Dialects",
  "Version": "1.19.7",
  "Date": "2026-09-18",
  "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",
  "Encoding": "UTF-8",
  "Config/roxygen2/version": "8.1.0",
  "Config/pak/sysreqs": "make default-jdk",
  "Repository": "https://ohdsi.r-universe.dev",
  "Date/Publication": "2026-09-18 13:06:00 UTC",
  "RemoteUrl": "https://github.com/ohdsi/sqlrender",
  "RemoteRef": "HEAD",
  "RemoteSha": "978673f61677702ca784f6cd525d448956460ca5",
  "NeedsCompilation": "no",
  "Packaged": {
    "Date": "2026-09-18 16:38:54 UTC",
    "User": "root"
  },
  "Author": "Martijn Schuemie [aut, cre],\nMarc Suchard [aut]",
  "_user": "ohdsi",
  "_type": "src",
  "_file": "SqlRender_1.19.7.tar.gz",
  "_fileid": "https://r2.ropensci.org/77d71c877d2a428de0c4aed4e188648d6ebf161a996ddc033afb76f1f6e67683",
  "_filesize": 608547,
  "_sha256": "77d71c877d2a428de0c4aed4e188648d6ebf161a996ddc033afb76f1f6e67683",
  "_expires": "2026-12-27T16:42:17.000Z",
  "_created": "2026-09-18T16:38:54.000Z",
  "_published": "2026-09-18T16:42:19.975Z",
  "_jobs": [
    {
      "job": 105680597285,
      "time": 162,
      "config": "linux-devel-x86_64",
      "r": "4.7.0",
      "check": "WARNING",
      "artifact": "10558600626"
    },
    {
      "job": 105680597268,
      "time": 155,
      "config": "linux-release-x86_64",
      "r": "4.6.1",
      "check": "WARNING",
      "artifact": "10558590657"
    },
    {
      "job": 105680598325,
      "time": 153,
      "config": "macos-oldrel-arm64",
      "r": "4.5.3",
      "check": "WARNING",
      "artifact": "10558435796"
    },
    {
      "job": 105680598386,
      "time": 113,
      "config": "macos-release-arm64",
      "r": "4.6.1",
      "check": "WARNING",
      "artifact": "10557651306"
    },
    {
      "job": 105679529226,
      "time": 203,
      "config": "source",
      "r": "4.6.1",
      "check": "OK",
      "artifact": "10557790848"
    },
    {
      "job": 105680597230,
      "time": 139,
      "config": "wasm-release",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "10557836095"
    },
    {
      "job": 105680597276,
      "time": 93,
      "config": "windows-devel-x86_64",
      "r": "4.7.0",
      "check": "WARNING",
      "artifact": "10557830987"
    },
    {
      "job": 105680597400,
      "time": 91,
      "config": "windows-oldrel-x86_64",
      "r": "4.5.3",
      "check": "WARNING",
      "artifact": "10557676105"
    },
    {
      "job": 105680597335,
      "time": 101,
      "config": "windows-release-x86_64",
      "r": "4.6.1",
      "check": "WARNING",
      "artifact": "10558055814"
    }
  ],
  "_host": "GitHub-Actions",
  "_buildurl": "https://github.com/r-universe/ohdsi/actions/runs/35369366547",
  "_status": "success",
  "_upstream": "https://github.com/ohdsi/sqlrender",
  "_commit": {
    "id": "978673f61677702ca784f6cd525d448956460ca5",
    "author": "schuemie <schuemie@ohdsi.org>",
    "committer": "schuemie <schuemie@ohdsi.org>",
    "message": "Updating CRAN-SUBMISSION\n",
    "time": 1789736760
  },
  "_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": 19,
  "_updates": [
    {
      "week": "2025-39",
      "n": 3
    },
    {
      "week": "2025-42",
      "n": 1
    },
    {
      "week": "2026-13",
      "n": 2
    },
    {
      "week": "2026-31",
      "n": 4
    },
    {
      "week": "2026-35",
      "n": 3
    },
    {
      "week": "2026-38",
      "n": 6
    }
  ],
  "_tags": [
    {
      "name": "v1.19.4",
      "date": "2025-09-27"
    },
    {
      "name": "v1.19.5",
      "date": "2026-03-25"
    },
    {
      "name": "v1.19.6",
      "date": "2026-07-31"
    },
    {
      "name": "v1.19.7",
      "date": "2026-09-18"
    }
  ],
  "_topics": [
    "hades",
    "openjdk"
  ],
  "_stars": 89,
  "_contributors": [
    {
      "user": "schuemie",
      "count": 450,
      "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": "maximmoinat",
      "count": 10,
      "uuid": 17825660
    },
    {
      "user": "myounglai",
      "count": 10,
      "uuid": 26904261
    },
    {
      "user": "anthonysena",
      "count": 9,
      "uuid": 12902366
    },
    {
      "user": "aklochkova",
      "count": 9,
      "uuid": 38942654
    },
    {
      "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": "karthikchundi-commits",
      "count": 1,
      "uuid": 265963303
    },
    {
      "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": 1099
  },
  "_downloads": {
    "count": 2953,
    "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": 0,
  "_rbuild": "4.6.1",
  "_assets": [
    "extra/citation.cff",
    "extra/citation.html",
    "extra/citation.json",
    "extra/citation.txt",
    "extra/contents.json",
    "extra/manual.pdf",
    "extra/NEWS.html",
    "extra/NEWS.txt",
    "extra/readme.html",
    "extra/readme.md",
    "extra/SqlRender.html"
  ],
  "_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"
    },
    {
      "version": "1.19.6",
      "date": "2026-07-31"
    }
  ],
  "_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.4+7-1~26.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": 10.43080081438579,
  "_indexed": true,
  "_nocasepkg": "sqlrender",
  "_universes": [
    "ohdsi",
    "schuemie"
  ],
  "_previous": "1.19.6",
  "_binaries": [
    {
      "r": "4.7.0",
      "os": "linux",
      "version": "1.19.7",
      "date": "2026-09-18T16:41:22.000Z",
      "distro": "resolute",
      "commit": "978673f61677702ca784f6cd525d448956460ca5",
      "fileid": "https://r2.ropensci.org/1069f4301d41b6406f1b9f201926c07ac12163daa2de2d0b0a5db1d19e8ea76a",
      "status": "success",
      "check": "WARNING",
      "buildurl": "https://github.com/r-universe/ohdsi/actions/runs/35369366547"
    },
    {
      "r": "4.6.1",
      "os": "linux",
      "version": "1.19.7",
      "date": "2026-09-18T16:41:18.000Z",
      "distro": "resolute",
      "commit": "978673f61677702ca784f6cd525d448956460ca5",
      "fileid": "https://r2.ropensci.org/0120e7d36f232312516c80456c358beac1d8826070dd180fb4c0e3051c4a6c9d",
      "status": "success",
      "check": "WARNING",
      "buildurl": "https://github.com/r-universe/ohdsi/actions/runs/35369366547"
    },
    {
      "r": "4.5.3",
      "os": "mac",
      "version": "1.19.7",
      "date": "2026-09-18T16:41:21.000Z",
      "commit": "978673f61677702ca784f6cd525d448956460ca5",
      "fileid": "https://r2.ropensci.org/695df496cbbc41f0bbe092d04fe88db918af65aed2504977a947601ae88d9b9d",
      "status": "success",
      "check": "WARNING",
      "buildurl": "https://github.com/r-universe/ohdsi/actions/runs/35369366547"
    },
    {
      "r": "4.6.1",
      "os": "mac",
      "version": "1.19.7",
      "date": "2026-09-18T16:40:45.000Z",
      "commit": "978673f61677702ca784f6cd525d448956460ca5",
      "fileid": "https://r2.ropensci.org/6fae6032fbb0192e5a6de8ef143c0714e9b49dc62a2d876a0e0bef455a0a648c",
      "status": "success",
      "check": "WARNING",
      "buildurl": "https://github.com/r-universe/ohdsi/actions/runs/35369366547"
    },
    {
      "r": "4.6.0",
      "os": "wasm",
      "version": "1.19.7",
      "date": "2026-09-18T16:41:30.000Z",
      "commit": "978673f61677702ca784f6cd525d448956460ca5",
      "fileid": "https://r2.ropensci.org/93ba26afbc706ce49791715f4935ef4a5584b6e3fe169ed8d267c60f1fc6380f",
      "status": "success",
      "buildurl": "https://github.com/r-universe/ohdsi/actions/runs/35369366547"
    },
    {
      "r": "4.7.0",
      "os": "win",
      "version": "1.19.7",
      "date": "2026-09-18T16:40:12.000Z",
      "commit": "978673f61677702ca784f6cd525d448956460ca5",
      "fileid": "https://r2.ropensci.org/052aad0e99bab05cdef3886e8b7cde0def37419603d38fa3fe6b672e08f7dce2",
      "status": "success",
      "check": "WARNING",
      "buildurl": "https://github.com/r-universe/ohdsi/actions/runs/35369366547"
    },
    {
      "r": "4.5.3",
      "os": "win",
      "version": "1.19.7",
      "date": "2026-09-18T16:40:01.000Z",
      "commit": "978673f61677702ca784f6cd525d448956460ca5",
      "fileid": "https://r2.ropensci.org/c3f328ab729451702d4469f9cb051c46eb43697ec632acf3c2cb772a7bfa0f97",
      "status": "success",
      "check": "WARNING",
      "buildurl": "https://github.com/r-universe/ohdsi/actions/runs/35369366547"
    },
    {
      "r": "4.6.1",
      "os": "win",
      "version": "1.19.7",
      "date": "2026-09-18T16:40:17.000Z",
      "commit": "978673f61677702ca784f6cd525d448956460ca5",
      "fileid": "https://r2.ropensci.org/ead79ba7279662d127cad53312df5b24fd9d1d325ff7a45ff85730329a0ff39d",
      "status": "success",
      "check": "WARNING",
      "buildurl": "https://github.com/r-universe/ohdsi/actions/runs/35369366547"
    }
  ]
}