{
  "_id": "6ab24c223d719c1f8408b6e3",
  "Package": "sqlq",
  "Title": "'SQL' Query Builder",
  "Version": "1.0.1",
  "Authors@R": "c(person(\"Pierrick\", \"Roger\", email=\"pierrick.roger@cea.fr\", role=c(\"aut\", \"cre\"), comment=c(ORCID=\"0000-0001-8177-4873\")))",
  "Maintainer": "Pierrick Roger <pierrick.roger@cea.fr>",
  "Description": "Allows to build complex 'SQL' (Structured Query Language)\nqueries dynamically. Classes and/or factory functions are used\nto produce a syntax tree from which the final character string\nis generated. Strings and identifiers are automatically quoted\nusing the right quotes, using either ANSI (American National\nStandards Institute) quoting or the quoting style of an\nexisting database connector. Style can be configured to set\nuppercase/lowercase for keywords, remove unnecessary spaces, or\nomit optional keywords.",
  "URL": "https://gitlab.com/cnrgh/databases/r-sqlq",
  "BugReports": "https://gitlab.com/cnrgh/databases/r-sqlq/-/issues",
  "License": "AGPL-3",
  "Encoding": "UTF-8",
  "NeedsCompilation": "no",
  "Roxygen": "list(markdown = TRUE)",
  "RoxygenNote": "7.3.2",
  "Collate": "'Statement.R' 'Expr.R' 'ExprBetween.R' 'ExprComp.R'\n'ExprBinOp.R' 'ExprCommOp.R' 'Token.R' 'TokenSymbol.R'\n'TokenIdentifier.R' 'ExprField.R' 'ExprFieldDef.R'\n'ExprIsNotNull.R' 'ExprIsNull.R' 'ExprList.R'\n'ExprListFields.R' 'ExprListValues.R' 'ExprUnaryOp.R' 'utils.R'\n'TokenValue.R' 'ExprValue.R' 'Query.R' 'QueryCreate.R'\n'QueryDelete.R' 'QueryInsert.R' 'QuerySelect.R' 'StmtSet.R'\n'StmtUpdate.R' 'QueryUpdate.R' 'StmtCreate.R' 'StmtDelete.R'\n'StmtFrom.R' 'StmtInsert.R' 'StmtJoin.R' 'StmtLimit.R'\n'StmtSelect.R' 'StmtSelectAll.R' 'StmtSelectFields.R'\n'StmtValues.R' 'StmtWhere.R' 'TokenEmpty.R' 'TokenKeyword.R'\n'factories.R' 'package.R' 'tokens.R'",
  "VignetteBuilder": "knitr",
  "Repository": "https://cnrgh.r-universe.dev",
  "Date/Publication": "2025-09-11 15:56:13 UTC",
  "RemoteUrl": "https://gitlab.com/cnrgh/databases/r-sqlq",
  "RemoteRef": "HEAD",
  "RemoteSha": "2ec97c82d6fd10ce91567ebe20178fee51a5cd7a",
  "Packaged": {
    "Date": "2026-09-22 09:31:46 UTC",
    "User": "root"
  },
  "Author": "Pierrick Roger [aut, cre] (ORCID:\n<https://orcid.org/0000-0001-8177-4873>)",
  "_user": "cnrgh",
  "_type": "src",
  "_file": "sqlq_1.0.1.tar.gz",
  "_fileid": "https://r2.ropensci.org/eda1ce671ac2a421b624e13517d175d5962640ac49b72de5d0f5b99c02b1b572",
  "_filesize": 78831,
  "_sha256": "eda1ce671ac2a421b624e13517d175d5962640ac49b72de5d0f5b99c02b1b572",
  "_expires": "2026-12-31T09:36:33.000Z",
  "_created": "2026-09-22T09:31:46.000Z",
  "_published": "2026-09-22T09:36:34.695Z",
  "_jobs": [
    {
      "job": 106691140690,
      "time": 156,
      "config": "linux-devel-x86_64",
      "r": "4.7.0",
      "check": "WARNING",
      "artifact": "10686567097"
    },
    {
      "job": 106691140700,
      "time": 141,
      "config": "linux-release-x86_64",
      "r": "4.6.1",
      "check": "WARNING",
      "artifact": "10686157532"
    },
    {
      "job": 106691140775,
      "time": 196,
      "config": "macos-oldrel-arm64",
      "r": "4.5.3",
      "check": "WARNING",
      "artifact": "10686282560"
    },
    {
      "job": 106691140735,
      "time": 178,
      "config": "macos-release-arm64",
      "r": "4.6.1",
      "check": "WARNING",
      "artifact": "10686512092"
    },
    {
      "job": 106689759939,
      "time": 254,
      "config": "source",
      "r": "4.6.1",
      "check": "ERROR",
      "artifact": "10687235796"
    },
    {
      "job": 106691140602,
      "time": 115,
      "config": "wasm-release",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "10686866719"
    },
    {
      "job": 106691140826,
      "time": 78,
      "config": "windows-devel-x86_64",
      "r": "4.7.0",
      "check": "WARNING",
      "artifact": "10686347040"
    },
    {
      "job": 106691140798,
      "time": 81,
      "config": "windows-oldrel-x86_64",
      "r": "4.5.3",
      "check": "WARNING",
      "artifact": "10686726715"
    },
    {
      "job": 106691140885,
      "time": 93,
      "config": "windows-release-x86_64",
      "r": "4.6.1",
      "check": "WARNING",
      "artifact": "10687021458"
    }
  ],
  "_host": "GitHub-Actions",
  "_buildurl": "https://github.com/r-universe/cnrgh/actions/runs/35710485758",
  "_status": "failure",
  "_upstream": "https://gitlab.com/cnrgh/databases/r-sqlq",
  "_commit": {
    "id": "2ec97c82d6fd10ce91567ebe20178fee51a5cd7a",
    "author": "Pierrick Roger <pierrick.rogermele@cea.fr>",
    "committer": "Pierrick Roger <pierrick.rogermele@cea.fr>",
    "message": "Bump patch number\n",
    "time": 1757606173
  },
  "_maintainer": {
    "name": "Pierrick Roger",
    "email": "pierrick.roger@cea.fr",
    "login": "pkrog",
    "description": "Research engineer at CNRGH",
    "uuid": 15377906,
    "orcid": "0000-0001-8177-4873"
  },
  "_distro": "resolute",
  "_registered": true,
  "_dependencies": [
    {
      "package": "R",
      "version": ">= 4.1",
      "role": "Depends"
    },
    {
      "package": "R6",
      "role": "Imports"
    },
    {
      "package": "chk",
      "role": "Imports"
    },
    {
      "package": "DBI",
      "role": "Imports"
    },
    {
      "package": "roxygen2",
      "role": "Suggests"
    },
    {
      "package": "testthat",
      "role": "Suggests"
    },
    {
      "package": "knitr",
      "role": "Suggests"
    },
    {
      "package": "rmarkdown",
      "role": "Suggests"
    },
    {
      "package": "covr",
      "role": "Suggests"
    },
    {
      "package": "cyclocomp",
      "role": "Suggests"
    },
    {
      "package": "lintr",
      "role": "Suggests"
    },
    {
      "package": "lgr",
      "role": "Suggests"
    },
    {
      "package": "RSQLite",
      "role": "Suggests"
    }
  ],
  "_owner": "gitlab-databases",
  "_selfowned": false,
  "_usedby": 1,
  "_updates": [],
  "_tags": [],
  "_userbio": {
    "uuid": 30862444,
    "type": "organization",
    "name": "CNRGH",
    "followers": 3,
    "description": "Centre National de Recherche en Génomique Humaine"
  },
  "_downloads": {
    "count": 421,
    "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/sqlq"
  },
  "_devurl": "https://gitlab.com/cnrgh/databases",
  "_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/readme.html",
    "extra/readme.md",
    "extra/sqlq.html"
  ],
  "_homeurl": "https://gitlab.com/cnrgh/databases/r-sqlq",
  "_realowner": "cnrgh",
  "_cranurl": true,
  "_releases": [
    {
      "version": "1.0.1",
      "date": "2025-09-16"
    }
  ],
  "_exports": [
    "apply_case",
    "Expr",
    "ExprBetween",
    "ExprBinOp",
    "ExprCommOp",
    "ExprComp",
    "ExprField",
    "ExprFieldDef",
    "ExprIsNotNull",
    "ExprIsNull",
    "ExprList",
    "ExprListFields",
    "ExprListValues",
    "ExprUnaryOp",
    "ExprValue",
    "make_between",
    "make_create_table",
    "make_delete",
    "make_fields",
    "make_insert",
    "make_join",
    "make_left_op",
    "make_middle_op",
    "make_row",
    "make_rows",
    "make_select",
    "make_select_all",
    "make_set",
    "make_update",
    "make_values",
    "make_where",
    "optspace",
    "Query",
    "QueryCreate",
    "QueryDelete",
    "QueryInsert",
    "QuerySelect",
    "QueryUpdate",
    "quote_ids",
    "quote_values",
    "Statement",
    "StmtCreate",
    "StmtDelete",
    "StmtFrom",
    "StmtInsert",
    "StmtJoin",
    "StmtLimit",
    "StmtSelect",
    "StmtSelectAll",
    "StmtSelectFields",
    "StmtSet",
    "StmtUpdate",
    "StmtValues",
    "StmtWhere",
    "Token",
    "TokenEmpty",
    "TokenIdentifier",
    "TokenKeyword",
    "TokenSymbol",
    "TokenValue"
  ],
  "_help": [],
  "_readme": "https://gitlab.com/cnrgh/databases/r-sqlq/raw/HEAD/README.md",
  "_rundeps": [
    "chk",
    "cli",
    "DBI",
    "lifecycle",
    "R6",
    "rlang"
  ],
  "_score": 3.1760912590556813,
  "_indexed": true,
  "_nocasepkg": "sqlq",
  "_universes": [
    "cnrgh",
    "pkrog",
    "gitlab-cnrgh"
  ],
  "_binaries": [
    {
      "r": "4.7.0",
      "os": "linux",
      "version": "1.0.1",
      "date": "2026-09-22T09:34:42.000Z",
      "distro": "resolute",
      "commit": "2ec97c82d6fd10ce91567ebe20178fee51a5cd7a",
      "fileid": "https://r2.ropensci.org/b3edbe015e8befd1831bd3b6f48fc6a59b486704be5fbf514df92e06e97b10b5",
      "status": "success",
      "check": "WARNING",
      "buildurl": "https://github.com/r-universe/cnrgh/actions/runs/35710485758"
    },
    {
      "r": "4.6.1",
      "os": "linux",
      "version": "1.0.1",
      "date": "2026-09-22T09:34:22.000Z",
      "distro": "resolute",
      "commit": "2ec97c82d6fd10ce91567ebe20178fee51a5cd7a",
      "fileid": "https://r2.ropensci.org/4b7f0bb4f13bdb6802574244f164498851bb404ba2211742807f52a21d6309a0",
      "status": "success",
      "check": "WARNING",
      "buildurl": "https://github.com/r-universe/cnrgh/actions/runs/35710485758"
    },
    {
      "r": "4.5.3",
      "os": "mac",
      "version": "1.0.1",
      "date": "2026-09-22T09:35:03.000Z",
      "commit": "2ec97c82d6fd10ce91567ebe20178fee51a5cd7a",
      "fileid": "https://r2.ropensci.org/a3eb9b30a9c97920dfe8d93c29fc8db2bd9d900fb03d8074a225c4e6381f1f16",
      "status": "success",
      "check": "WARNING",
      "buildurl": "https://github.com/r-universe/cnrgh/actions/runs/35710485758"
    },
    {
      "r": "4.6.1",
      "os": "mac",
      "version": "1.0.1",
      "date": "2026-09-22T09:34:23.000Z",
      "commit": "2ec97c82d6fd10ce91567ebe20178fee51a5cd7a",
      "fileid": "https://r2.ropensci.org/c43c16552828008262f8ab303c8fbc2cf78b3a5c162d14e5588cfc0b91913a4c",
      "status": "success",
      "check": "WARNING",
      "buildurl": "https://github.com/r-universe/cnrgh/actions/runs/35710485758"
    },
    {
      "r": "4.6.0",
      "os": "wasm",
      "version": "1.0.1",
      "date": "2026-09-22T09:34:22.000Z",
      "commit": "2ec97c82d6fd10ce91567ebe20178fee51a5cd7a",
      "fileid": "https://r2.ropensci.org/93de1b62f98ae599ce920db060f646945ace37d881722ea882f6abb58c0aaa88",
      "status": "success",
      "buildurl": "https://github.com/r-universe/cnrgh/actions/runs/35710485758"
    },
    {
      "r": "4.7.0",
      "os": "win",
      "version": "1.0.1",
      "date": "2026-09-22T09:33:12.000Z",
      "commit": "2ec97c82d6fd10ce91567ebe20178fee51a5cd7a",
      "fileid": "https://r2.ropensci.org/80613ae69636b98e1f564e751a8b3f9989ef5c8fa2bcd9d3874eb972a8366435",
      "status": "success",
      "check": "WARNING",
      "buildurl": "https://github.com/r-universe/cnrgh/actions/runs/35710485758"
    },
    {
      "r": "4.5.3",
      "os": "win",
      "version": "1.0.1",
      "date": "2026-09-22T09:33:15.000Z",
      "commit": "2ec97c82d6fd10ce91567ebe20178fee51a5cd7a",
      "fileid": "https://r2.ropensci.org/1e9117aef17f57e3d42a5ced807ccff424a28c2549e4cb909d3d701145d24578",
      "status": "success",
      "check": "WARNING",
      "buildurl": "https://github.com/r-universe/cnrgh/actions/runs/35710485758"
    },
    {
      "r": "4.6.1",
      "os": "win",
      "version": "1.0.1",
      "date": "2026-09-22T09:33:18.000Z",
      "commit": "2ec97c82d6fd10ce91567ebe20178fee51a5cd7a",
      "fileid": "https://r2.ropensci.org/40c0ffc63e0e50aea68cfa3afc2dda5b8360e26cf4a83f8bec789430d247571a",
      "status": "success",
      "check": "WARNING",
      "buildurl": "https://github.com/r-universe/cnrgh/actions/runs/35710485758"
    }
  ]
}