{ "_id": "6a1f33dbb401979e73428268", "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 ", "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", "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", "Packaged": { "Date": "2026-05-15 07:06:59 UTC", "User": "root" }, "Author": "Pierrick Roger [aut, cre] (ORCID:\n)", "Repository": "https://pkrog.r-universe.dev", "Date/Publication": "2025-09-16 07:40:02 UTC", "RemoteUrl": "https://github.com/cran/sqlq", "RemoteRef": "HEAD", "RemoteSha": "937108373858352b70d8170cffac3a5bb9e26a1a", "MD5sum": "ce024f66f55e480edde9fbec818dc31b", "_user": "pkrog", "_type": "src", "_file": "sqlq_1.0.1.tar.gz", "_fileid": "1d6799740f35241c70314517d0de281d0f01450ca0654b7fd11727d2559a6439", "_filesize": 247860, "_sha256": "1d6799740f35241c70314517d0de281d0f01450ca0654b7fd11727d2559a6439", "_created": "2026-05-15T07:06:59.000Z", "_published": "2026-06-02T19:49:47.683Z", "_distro": "noble", "_jobs": [ { "job": 79158473912, "time": 150, "config": "linux-devel-x86_64", "r": "4.7.0", "check": "OK", "artifact": "7011961668" }, { "job": 79158474281, "time": 149, "config": "linux-release-x86_64", "r": "4.6.0", "check": "OK", "artifact": "7011961694" }, { "job": 79158473337, "time": 233, "config": "macos-oldrel-arm64", "r": "4.5.3", "check": "OK", "artifact": "7011974918" }, { "job": 79158473852, "time": 208, "config": "macos-release-arm64", "r": "4.6.0", "check": "OK", "artifact": "7011966269" }, { "job": 79158473150, "time": 229, "config": "source", "r": "4.6.0", "check": "OK", "artifact": "7011924201" }, { "job": 79158472835, "time": 106, "config": "wasm-release", "r": "4.6.0", "check": "OK", "artifact": "7368206241" }, { "job": 79158473399, "time": 113, "config": "windows-devel", "r": "4.7.0", "check": "OK", "artifact": "7011952336" }, { "job": 79158473537, "time": 100, "config": "windows-oldrel", "r": "4.5.3", "check": "OK", "artifact": "7011949264" }, { "job": 79158474078, "time": 102, "config": "windows-release", "r": "4.6.0", "check": "OK", "artifact": "7011949720" } ], "_buildurl": "https://github.com/r-universe/pkrog/actions/runs/25905116217", "_status": "success", "_host": "GitHub-Actions", "_upstream": "https://github.com/cran/sqlq", "_commit": { "id": "937108373858352b70d8170cffac3a5bb9e26a1a", "author": "Pierrick Roger ", "committer": "cran-robot ", "message": "version 1.0.1\n", "time": 1758008402 }, "_maintainer": { "name": "Pierrick Roger", "email": "pierrick.roger@cea.fr", "login": "pkrog", "uuid": 15377906, "orcid": "0000-0001-8177-4873" }, "_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": "cran", "_selfowned": true, "_usedby": 2, "_updates": [ { "week": "2025-38", "n": 1 } ], "_tags": [ { "name": "1.0.1", "date": "2025-09-16" } ], "_stars": 0, "_contributors": [ { "user": "pkrog", "count": 1, "uuid": 15377906 } ], "_userbio": { "uuid": 15377906, "type": "user", "name": "Pierrick Roger", "description": "Research engineer at CNRGH" }, "_downloads": { "count": 659, "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/sqlq" }, "_devurl": "https://gitlab.com/cnrgh/databases", "_searchresults": 0, "_rbuild": "4.6.0", "_assets": [ "extra/citation.cff", "extra/citation.html", "extra/citation.json", "extra/citation.txt", "extra/contents.json", "extra/sqlq.html", "manual.pdf" ], "_realowner": "pkrog", "_cranurl": false, "_releases": [ { "version": "1.0.1", "date": "2025-09-16" } ], "_exports": [ "Expr", "ExprBetween", "ExprBinOp", "ExprCommOp", "ExprField", "ExprFieldDef", "ExprIsNotNull", "ExprIsNull", "ExprList", "ExprListFields", "ExprListValues", "ExprUnaryOp", "ExprValue", "make_between", "make_create_table", "make_delete", "make_fields", "make_insert", "make_join", "make_row", "make_rows", "make_select", "make_select_all", "make_set", "make_update", "make_values", "make_where", "Query", "QueryCreate", "QueryDelete", "QueryInsert", "QuerySelect", "QueryUpdate", "Statement", "StmtCreate", "StmtDelete", "StmtFrom", "StmtInsert", "StmtJoin", "StmtLimit", "StmtSelect", "StmtSelectAll", "StmtSelectFields", "StmtSet", "StmtUpdate", "StmtValues", "StmtWhere" ], "_help": [ { "page": "sqlq-package", "title": "sqlq: 'SQL' Query Builder", "topics": [ "sqlq-package", "sqlq" ] }, { "page": "apply_case", "title": "Put string in right case according to global option.", "topics": [ "apply_case" ] }, { "page": "Expr", "title": "Expression abstact class.", "topics": [ "Expr" ] }, { "page": "ExprBetween", "title": "This class represents an SQL BETWEEN expression.", "topics": [ "ExprBetween" ] }, { "page": "ExprBinOp", "title": "This class represents an SQL binary operator.", "topics": [ "ExprBinOp" ] }, { "page": "ExprCommOp", "title": "This class represents an SQL logical operator.", "topics": [ "ExprCommOp" ] }, { "page": "ExprComp", "title": "Composed Expression class.", "topics": [ "ExprComp" ] }, { "page": "ExprField", "title": "This class represents an SQL field.", "topics": [ "ExprField" ] }, { "page": "ExprFieldDef", "title": "Table field definition.", "topics": [ "ExprFieldDef" ] }, { "page": "ExprIsNotNull", "title": "This class represents the IS NOT NULL test.", "topics": [ "ExprIsNotNull" ] }, { "page": "ExprIsNull", "title": "This class represents the IS NULL test.", "topics": [ "ExprIsNull" ] }, { "page": "ExprList", "title": "This class represents an SQL list.", "topics": [ "ExprList" ] }, { "page": "ExprListFields", "title": "This class represents a list of fields.", "topics": [ "ExprListFields" ] }, { "page": "ExprListValues", "title": "This class represents a list of values.", "topics": [ "ExprListValues" ] }, { "page": "ExprUnaryOp", "title": "This class represents an SQL unary operator.", "topics": [ "ExprUnaryOp" ] }, { "page": "ExprValue", "title": "This class represents an SQL value.", "topics": [ "ExprValue" ] }, { "page": "make_between", "title": "Create a BETWEEN expression.", "topics": [ "make_between" ] }, { "page": "make_create_table", "title": "Create an SQL CREATE TABLE query.", "topics": [ "make_create_table" ] }, { "page": "make_delete", "title": "Create an SQL DELETE FROM query.", "topics": [ "make_delete" ] }, { "page": "make_fields", "title": "Create a list of table fields.", "topics": [ "make_fields" ] }, { "page": "make_insert", "title": "Create an SQL INSERT INTO query.", "topics": [ "make_insert" ] }, { "page": "make_join", "title": "Create a SQL JOIN statement.", "topics": [ "make_join" ] }, { "page": "make_row", "title": "Create a list of SQL values.", "topics": [ "make_row" ] }, { "page": "make_rows", "title": "Create a list of rows of values", "topics": [ "make_rows" ] }, { "page": "make_select", "title": "Create an SQL SELECT query.", "topics": [ "make_select" ] }, { "page": "make_select_all", "title": "Create an SQL SELECT query for all fields.", "topics": [ "make_select_all" ] }, { "page": "make_set", "title": "Create an SQL SET statement.", "topics": [ "make_set" ] }, { "page": "make_update", "title": "Create an SQL UPDATE query.", "topics": [ "make_update" ] }, { "page": "make_values", "title": "Create a list of SQL values.", "topics": [ "make_values" ] }, { "page": "make_where", "title": "Create a WHERE clause.", "topics": [ "make_where" ] }, { "page": "Query", "title": "This class handles an SQL Query.", "topics": [ "Query" ] }, { "page": "QueryCreate", "title": "Create query.", "topics": [ "QueryCreate" ] }, { "page": "QueryDelete", "title": "Delete query.", "topics": [ "QueryDelete" ] }, { "page": "QueryInsert", "title": "Insert query.", "topics": [ "QueryInsert" ] }, { "page": "QuerySelect", "title": "Class for the SELECT query.", "topics": [ "QuerySelect" ] }, { "page": "QueryUpdate", "title": "Update Query.", "topics": [ "QueryUpdate" ] }, { "page": "quote_ids", "title": "Quote identifiers (e.g.: table names or field names) for SQL queries.", "topics": [ "quote_ids" ] }, { "page": "quote_values", "title": "Quote character values for SQL queries.", "topics": [ "quote_values" ] }, { "page": "Statement", "title": "Abstract class that represents an SQL statement.", "topics": [ "Statement" ] }, { "page": "StmtCreate", "title": "CREATE TABLE statement.", "topics": [ "StmtCreate" ] }, { "page": "StmtDelete", "title": "DELETE FROM statement.", "topics": [ "StmtDelete" ] }, { "page": "StmtFrom", "title": "SQL From statement.", "topics": [ "StmtFrom" ] }, { "page": "StmtInsert", "title": "INSERT INTO statement.", "topics": [ "StmtInsert" ] }, { "page": "StmtJoin", "title": "SQL JOIN statement.", "topics": [ "StmtJoin" ] }, { "page": "StmtLimit", "title": "LIMIT statement.", "topics": [ "StmtLimit" ] }, { "page": "StmtSelect", "title": "Abstract SELECT statement.", "topics": [ "StmtSelect" ] }, { "page": "StmtSelectAll", "title": "SELECT * statement.", "topics": [ "StmtSelectAll" ] }, { "page": "StmtSelectFields", "title": "SELECT fields statement.", "topics": [ "StmtSelectFields" ] }, { "page": "StmtSet", "title": "SET statement.", "topics": [ "StmtSet" ] }, { "page": "StmtUpdate", "title": "UPDATE statement.", "topics": [ "StmtUpdate" ] }, { "page": "StmtValues", "title": "VALUES statement.", "topics": [ "StmtValues" ] }, { "page": "StmtWhere", "title": "SQL WHERE statement.", "topics": [ "StmtWhere" ] }, { "page": "Token", "title": "Abstract Token class.", "topics": [ "Token" ] }, { "page": "TokenEmpty", "title": "Empty token class.", "topics": [ "TokenEmpty" ] }, { "page": "TokenIdentifier", "title": "TokenIdentifier class.", "topics": [ "TokenIdentifier" ] }, { "page": "TokenKeyword", "title": "TokenKeyword class.", "topics": [ "TokenKeyword" ] }, { "page": "TokenSymbol", "title": "TokenSymbol class.", "topics": [ "TokenSymbol" ] }, { "page": "TokenValue", "title": "Token value class.", "topics": [ "TokenValue" ] } ], "_rundeps": [ "chk", "cli", "DBI", "lifecycle", "R6", "rlang" ], "_vignettes": [ { "source": "intro.Rmd", "filename": "intro.html", "title": "Introduction to sqlq package", "engine": "knitr::rmarkdown", "headings": [ "SELECT query", "Selecting specific fields", "LIMIT keyword", "WHERE clause", "Complex where clause", "Dynamic where clause", "JOIN statement", "Setting the type of JOIN", "Join on multiple tables", "INSERT INTO query", "CREATE TABLE query", "DELETE FROM query", "UPDATE query", "Noticeable expressions", "Binary operators", "Commutative operators", "BETWEEN", "IS NULL and IS NOT NULL", "Style options", "Using proper quoting for a specific database", "Keywords uppercase/lowercase", "Spaces" ], "created": "2025-09-16 07:40:02", "modified": "2025-09-16 07:40:02", "commits": 1 } ], "_score": 2.778151250383644, "_indexed": true, "_nocasepkg": "sqlq", "_universes": [ "pkrog", "gitlab-cnrgh" ], "_binaries": [ { "r": "4.7.0", "os": "linux", "version": "1.0.1", "date": "2026-05-15T07:09:25.000Z", "distro": "noble", "commit": "937108373858352b70d8170cffac3a5bb9e26a1a", "fileid": "e531eef17f3f92a73bd075ac0791e56ba7dcaa7f58d3d59989315893abae0c53", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/pkrog/actions/runs/25905116217" }, { "r": "4.6.0", "os": "linux", "version": "1.0.1", "date": "2026-05-15T07:09:27.000Z", "distro": "noble", "commit": "937108373858352b70d8170cffac3a5bb9e26a1a", "fileid": "ea46e704a9fbf53e2bc58f8be8067cb4012b2b30e310f9bc44934428fc4c4c87", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/pkrog/actions/runs/25905116217" }, { "r": "4.5.3", "os": "mac", "version": "1.0.1", "date": "2026-05-15T07:10:25.000Z", "commit": "937108373858352b70d8170cffac3a5bb9e26a1a", "fileid": "a27afcb2a80c4418caeda7e24c98396ecc1f3f0bae6530074cbef3d8cc8bcfa2", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/pkrog/actions/runs/25905116217" }, { "r": "4.6.0", "os": "mac", "version": "1.0.1", "date": "2026-05-15T07:09:41.000Z", "commit": "937108373858352b70d8170cffac3a5bb9e26a1a", "fileid": "888dbe0a7e9cb44afa099d6d0fab428eb6b24732e9fdcf4e983a86e418a474d8", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/pkrog/actions/runs/25905116217" }, { "r": "4.7.0", "os": "win", "version": "1.0.1", "date": "2026-05-15T07:08:49.000Z", "commit": "937108373858352b70d8170cffac3a5bb9e26a1a", "fileid": "71d1b25f005dde2d5ae8dc1bfb708249ed953420c1a343a4e50a271bd845b8a4", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/pkrog/actions/runs/25905116217" }, { "r": "4.5.3", "os": "win", "version": "1.0.1", "date": "2026-05-15T07:08:29.000Z", "commit": "937108373858352b70d8170cffac3a5bb9e26a1a", "fileid": "cf8861ff5ee1f5543b8d507477811fb407ad14cbcfb736895f468fefe493de64", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/pkrog/actions/runs/25905116217" }, { "r": "4.6.0", "os": "win", "version": "1.0.1", "date": "2026-05-15T07:08:30.000Z", "commit": "937108373858352b70d8170cffac3a5bb9e26a1a", "fileid": "6dea75347819284a110b624be49e23f7126cd48b095781869fcdc4f4eb0e0e32", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/pkrog/actions/runs/25905116217" }, { "r": "4.6.0", "os": "wasm", "version": "1.0.1", "date": "2026-06-02T19:49:26.000Z", "commit": "937108373858352b70d8170cffac3a5bb9e26a1a", "fileid": "531eead41b49db681edb011e85840b29c2d76e1c1fb477b71aadd82faf87c220", "status": "success", "buildurl": "https://github.com/r-universe/pkrog/actions/runs/25905116217" } ] }