{
  "_id": "6a12ad57acfb0bcc41d186fe",
  "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",
  "NeedsCompilation": "no",
  "Packaged": {
    "Date": "2026-05-24 07:45:16 UTC",
    "User": "root"
  },
  "Author": "Martijn Schuemie [aut, cre], Marc Suchard [aut]",
  "Config/pak/sysreqs": "default-jdk",
  "Repository": "https://cran.r-universe.dev",
  "Date/Publication": "2026-03-25 06:11:16 UTC",
  "RemoteUrl": "https://github.com/cran/SqlRender",
  "RemoteRef": "HEAD",
  "RemoteSha": "4ac9f66d099aee4734e8948c1c50a86618c1cee6",
  "MD5sum": "472113706c16c57518aefa6fbf086bfd",
  "_user": "cran",
  "_type": "src",
  "_file": "SqlRender_1.19.5.tar.gz",
  "_fileid": "809a4dde3acea7072f63ddff40d69983964c0f073aab92a4f6392d5a2a3babb5",
  "_filesize": 604970,
  "_sha256": "809a4dde3acea7072f63ddff40d69983964c0f073aab92a4f6392d5a2a3babb5",
  "_created": "2026-05-24T07:45:16.000Z",
  "_published": "2026-05-24T07:48:39.633Z",
  "_distro": "noble",
  "_jobs": [
    {
      "job": 77581382660,
      "time": 144,
      "config": "linux-devel-x86_64",
      "r": "4.7.0",
      "check": "WARNING",
      "artifact": "7183392135"
    },
    {
      "job": 77581382661,
      "time": 162,
      "config": "linux-release-x86_64",
      "r": "4.6.0",
      "check": "WARNING",
      "artifact": "7183393899"
    },
    {
      "job": 77581184278,
      "time": 224,
      "config": "source",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "7183376522"
    },
    {
      "job": 77581382663,
      "time": 131,
      "config": "wasm-release",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "7183390683"
    }
  ],
  "_buildurl": "https://github.com/r-universe/cran/actions/runs/26355419960",
  "_status": "success",
  "_host": "GitHub-Actions",
  "_upstream": "https://github.com/cran/SqlRender",
  "_commit": {
    "id": "4ac9f66d099aee4734e8948c1c50a86618c1cee6",
    "author": "Martijn Schuemie <schuemie@ohdsi.org>",
    "committer": "cran-robot <csardi.gabor+cran@gmail.com>",
    "message": "version 1.19.5\n",
    "time": 1774419076
  },
  "_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": "cran",
  "_selfowned": false,
  "_usedby": 17,
  "_updates": [
    {
      "week": "2025-34",
      "n": 1
    },
    {
      "week": "2025-39",
      "n": 1
    },
    {
      "week": "2026-13",
      "n": 1
    }
  ],
  "_tags": [
    {
      "name": "1.19.3",
      "date": "2025-08-19"
    },
    {
      "name": "1.19.4",
      "date": "2025-09-26"
    },
    {
      "name": "1.19.5",
      "date": "2026-03-25"
    }
  ],
  "_stars": 0,
  "_contributors": [
    {
      "user": "schuemie",
      "count": 46,
      "uuid": 6713328
    }
  ],
  "_userbio": {
    "uuid": 6899542,
    "type": "organization",
    "name": "cran",
    "description": "Unofficial read-only mirror of all CRAN R packages"
  },
  "_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,
  "_topics": [
    "openjdk"
  ],
  "_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": false,
  "_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/cran/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": "2016-08-16 19:47:24",
      "modified": "2024-10-09 07:00:03",
      "commits": 19
    }
  ],
  "_score": 7.427832457128451,
  "_indexed": false,
  "_nocasepkg": "sqlrender",
  "_universes": [
    "cran"
  ],
  "_indexurl": "https://ohdsi.r-universe.dev/SqlRender",
  "_binaries": [
    {
      "r": "4.7.0",
      "os": "linux",
      "version": "1.19.5",
      "date": "2026-05-24T07:47:32.000Z",
      "distro": "noble",
      "commit": "4ac9f66d099aee4734e8948c1c50a86618c1cee6",
      "fileid": "399f26b8ebb9b85ec795ff3c84309e5eb282336a420787f750939f1761ed6b63",
      "status": "success",
      "check": "WARNING",
      "buildurl": "https://github.com/r-universe/cran/actions/runs/26355419960"
    },
    {
      "r": "4.6.0",
      "os": "linux",
      "version": "1.19.5",
      "date": "2026-05-24T07:47:47.000Z",
      "distro": "noble",
      "commit": "4ac9f66d099aee4734e8948c1c50a86618c1cee6",
      "fileid": "a6e2dadde92696843468366628236576000bff219530c1e4798a7a2a5870938b",
      "status": "success",
      "check": "WARNING",
      "buildurl": "https://github.com/r-universe/cran/actions/runs/26355419960"
    },
    {
      "r": "4.6.0",
      "os": "wasm",
      "version": "1.19.5",
      "date": "2026-05-24T07:47:47.000Z",
      "commit": "4ac9f66d099aee4734e8948c1c50a86618c1cee6",
      "fileid": "a050348a5a92beb7a968d1b09ea08b9d6bdd8767b3ebf17c6f7ee7548d717dc0",
      "status": "success",
      "buildurl": "https://github.com/r-universe/cran/actions/runs/26355419960"
    }
  ]
}