{ "_id": "6ab38bae3d719c1f84090fd9", "Package": "RSQL", "Type": "Package", "Title": "Database Agnostic Package to Generate and Process 'SQL' Queries\nin R", "Version": "0.2.2", "Language": "en-US", "Authors@R": "c(\nperson(\"Alejandro\", \"Baranek\",,\"abaranek@dc.uba.ar\", c(\"cre\", \"aut\")),\nperson(\"Leonardo\",\"Belen\",,\"leobelen@gmail.com\", c(\"aut\")))", "Maintainer": "Alejandro Baranek ", "Description": "Allows the user to generate and execute select, insert,\nupdate and delete 'SQL' queries the underlying database without\nhaving to explicitly write 'SQL' code.", "License": "MIT + file LICENSE", "Encoding": "UTF-8", "RoxygenNote": "7.2.3", "Collate": "'sql-lib.R' 'util-lib.R' 'zzz.R'", "VignetteBuilder": "knitr", "BugReports": "https://github.com/rOpenStats/RSQL/issues", "URL": "https://github.com/rOpenStats/RSQL", "Repository": "https://ropenstats.r-universe.dev", "Date/Publication": "2023-08-19 13:42:25 UTC", "RemoteUrl": "https://github.com/ropenstats/rsql", "RemoteRef": "HEAD", "RemoteSha": "e89b916a85c6a9c0cefa5c238b0a309a676e8b3a", "NeedsCompilation": "no", "Packaged": { "Date": "2026-09-23 08:15:52 UTC", "User": "root" }, "Author": "Alejandro Baranek [cre, aut],\nLeonardo Belen [aut]", "_user": "ropenstats", "_type": "src", "_file": "RSQL_0.2.2.tar.gz", "_fileid": "https://r2.ropensci.org/e1467a5a23fb8537a6bef12cf01cd5cde23f1a9bc86df0626fd95da0001b2f8d", "_filesize": 171368, "_sha256": "e1467a5a23fb8537a6bef12cf01cd5cde23f1a9bc86df0626fd95da0001b2f8d", "_expires": "2027-01-01T08:19:56.000Z", "_created": "2026-09-23T08:15:52.000Z", "_published": "2026-09-23T08:19:57.790Z", "_jobs": [ { "job": 107100029502, "time": 144, "config": "linux-devel-x86_64", "r": "4.7.0", "check": "OK", "artifact": "10739626751" }, { "job": 107100029386, "time": 136, "config": "linux-release-x86_64", "r": "4.6.1", "check": "OK", "artifact": "10739631862" }, { "job": 107100029318, "time": 150, "config": "macos-oldrel-arm64", "r": "4.5.3", "check": "OK", "artifact": "10739597087" }, { "job": 107100029343, "time": 115, "config": "macos-release-arm64", "r": "4.6.1", "check": "OK", "artifact": "10739780488" }, { "job": 107098939404, "time": 212, "config": "source", "r": "4.6.1", "check": "OK", "artifact": "10739770107" }, { "job": 107100029357, "time": 114, "config": "wasm-release", "r": "4.6.0", "check": "OK", "artifact": "10738818387" }, { "job": 107100029433, "time": 84, "config": "windows-devel-x86_64", "r": "4.7.0", "check": "OK", "artifact": "10738583812" }, { "job": 107100029387, "time": 67, "config": "windows-oldrel-x86_64", "r": "4.5.3", "check": "OK", "artifact": "10738843275" }, { "job": 107100029477, "time": 79, "config": "windows-release-x86_64", "r": "4.6.1", "check": "OK", "artifact": "10738613674" } ], "_host": "GitHub-Actions", "_buildurl": "https://github.com/r-universe/ropenstats/actions/runs/35835799600", "_status": "success", "_upstream": "https://github.com/ropenstats/rsql", "_commit": { "id": "e89b916a85c6a9c0cefa5c238b0a309a676e8b3a", "author": "alejandro baranek ", "committer": "alejandro baranek ", "message": "CRAN submission\n", "time": 1692452545 }, "_maintainer": { "name": "Alejandro Baranek", "email": "abaranek@dc.uba.ar", "login": "kenarab", "twitter": "@ken4rab", "description": "", "uuid": 2932950 }, "_distro": "resolute", "_registered": true, "_dependencies": [ { "package": "lgr", "role": "Imports" }, { "package": "R6", "role": "Imports" }, { "package": "DBI", "role": "Imports" }, { "package": "RSQLite", "role": "Suggests" }, { "package": "RMySQL", "role": "Suggests" }, { "package": "RPostgres", "role": "Suggests" }, { "package": "knitr", "role": "Suggests" }, { "package": "rmarkdown", "role": "Suggests" }, { "package": "dplyr", "role": "Suggests" }, { "package": "testthat", "role": "Suggests" }, { "package": "covr", "role": "Suggests" }, { "package": "lintr", "role": "Suggests" }, { "package": "pkgdown", "role": "Suggests" } ], "_owner": "ropenstats", "_selfowned": true, "_usedby": 0, "_updates": [], "_tags": [], "_stars": 10, "_contributors": [ { "user": "kenarab", "count": 140, "uuid": 2932950 }, { "user": "leobelen", "count": 26, "uuid": 797345 }, { "user": "romainfrancois", "count": 1, "uuid": 2625526 } ], "_userbio": { "uuid": 32276012, "type": "organization", "name": "rOpenStats", "followers": 3 }, "_downloads": { "count": 299, "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/RSQL" }, "_devurl": "https://github.com/ropenstats/rsql", "_searchresults": 29, "_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/RSQL.html", "LICENSE" ], "_homeurl": "https://github.com/ropenstats/rsql", "_realowner": "ropenstats", "_cranurl": true, "_releases": [ { "version": "0.1.1", "date": "2020-02-05" }, { "version": "0.1.3", "date": "2020-05-06" }, { "version": "0.1.4", "date": "2020-07-05" }, { "version": "0.2.0", "date": "2022-04-14" }, { "version": "0.2.1", "date": "2022-05-21" }, { "version": "0.2.2", "date": "2023-08-19" } ], "_exports": [ "add_quotes", "createRSQL", "genLogger", "getLogger", "getMtcarsdbPath", "getPackageDir", "loggerSetupFile", "RSQL.class" ], "_help": [ { "page": "grapes-IN-grapes", "title": "Operator IN for multiple columns", "topics": [ "%IN%" ] }, { "page": "add_grep_exact_match", "title": "add_grep_exact_match", "topics": [ "add_grep_exact_match" ] }, { "page": "add_quotes", "title": "add_quotes", "topics": [ "add_quotes" ] }, { "page": "assessRSqlDf", "title": "assessRSqlDf", "topics": [ "assessRSqlDf" ] }, { "page": "cbind_coerced", "title": "cbind_coerced", "topics": [ "cbind_coerced" ] }, { "page": "check_fields_values", "title": "Check fields and values are sound", "topics": [ "check_fields_values" ] }, { "page": "createRSQL", "title": "Produces a RSQL object", "topics": [ "createRSQL" ] }, { "page": "dequote", "title": "Removes the quotes from the string", "topics": [ "dequote" ] }, { "page": "df_verify", "title": "Checks that the columns are in the data.frame", "topics": [ "df_verify" ] }, { "page": "genLogger", "title": "genLogger", "topics": [ "genLogger" ] }, { "page": "getLogger", "title": "getLogger", "topics": [ "getLogger" ] }, { "page": "getMtcarsdbPath", "title": "getCarsdbPath", "topics": [ "getMtcarsdbPath" ] }, { "page": "getPackageDir", "title": "Get package directory", "topics": [ "getPackageDir" ] }, { "page": "is_quoted", "title": "Determines if the string is quoted or not", "topics": [ "is_quoted" ] }, { "page": "is.POSIXct", "title": "is.POSIXct", "topics": [ "is.POSIXct" ] }, { "page": "loggerSetupFile", "title": "loggerSetupFile", "topics": [ "loggerSetupFile" ] }, { "page": "needs_quotes", "title": "Determines string type which needs quotes in an SQL statement", "topics": [ "needs_quotes" ] }, { "page": "parse_where_clause", "title": "Parses a where clause.", "topics": [ "parse_where_clause" ] }, { "page": "re_quote", "title": "This functions remove original quotes and sets validated quotes for corresponding db. If it had no quotes, will only put corresponding quotes symbols", "topics": [ "re_quote" ] }, { "page": "re_quote_alt", "title": "This functions remove original quotes and sets validated quotes for corresponding db. If it had no quotes, will only put corresponding quotes symbols", "topics": [ "re_quote_alt" ] }, { "page": "rename_col", "title": "rename_col", "topics": [ "rename_col" ] }, { "page": "replaceNAwithNULL", "title": "replaceNAwithNULL", "topics": [ "replaceNAwithNULL" ] }, { "page": "rm_quotes", "title": "rm_quotes", "topics": [ "rm_quotes" ] }, { "page": "rm_vector_quotes", "title": "rm_vector_quotes", "topics": [ "rm_vector_quotes" ] }, { "page": "RSQL", "title": "rsql", "topics": [ "RSQL-package", ".onLoad", "RSQL" ] }, { "page": "RSQL.class", "title": "The class that provides the SQL functionality.", "topics": [ "RSQL.class" ] }, { "page": "sql_execute_delete", "title": "sql_execute_delete", "topics": [ "sql_execute_delete" ] }, { "page": "sql_execute_get_insert", "title": "sql_execute_get_insert", "topics": [ "sql_execute_get_insert" ] }, { "page": "sql_execute_insert", "title": "Executes a statement on the database.", "topics": [ "sql_execute_insert" ] }, { "page": "sql_execute_select", "title": "sql_execute_select", "topics": [ "sql_execute_select" ] }, { "page": "sql_execute_update", "title": "Executes an update on the database", "topics": [ "sql_execute_update" ] }, { "page": "sql_gen_delete", "title": "sql_gen_delete", "topics": [ "sql_gen_delete" ] }, { "page": "sql_gen_insert", "title": "sql_gen_insert", "topics": [ "sql_gen_insert" ] }, { "page": "sql_gen_select", "title": "sql_gen_select", "topics": [ "sql_gen_select" ] }, { "page": "sql_gen_update", "title": "sql_gen_update", "topics": [ "sql_gen_update" ] }, { "page": "sql_gen_where", "title": "sql_gen_where", "topics": [ "sql_gen_where" ] }, { "page": "sql_gen_where_list", "title": "sql_gen_where_list", "topics": [ "sql_gen_where_list" ] }, { "page": "sql_gen_where_or", "title": "sql_gen_where_or", "topics": [ "sql_gen_where_or" ] }, { "page": "sql_retrieve", "title": "Retrieves Statement", "topics": [ "sql_retrieve" ] }, { "page": "sql_retrieve_insert", "title": "Retrieves or insert Statement", "topics": [ "sql_retrieve_insert" ] }, { "page": "stuff_df_quoted", "title": "stuff_df_quoted", "topics": [ "stuff_df_quoted" ] }, { "page": "stuff_quote", "title": "Stuff quote symbol from text", "topics": [ "stuff_quote" ] }, { "page": "times_to_utc", "title": "times_to_utc", "topics": [ "times_to_utc" ] }, { "page": "trim", "title": "Returns string w/o leading or trailing whitespace", "topics": [ "trim" ] }, { "page": "trim_leading", "title": "trim_leading", "topics": [ "trim_leading" ] }, { "page": "trim_trailing", "title": "trim_trailing", "topics": [ "trim_trailing" ] } ], "_readme": "https://github.com/ropenstats/rsql/raw/HEAD/README.md", "_rundeps": [ "DBI", "lgr", "R6" ], "_vignettes": [ { "source": "rsql.Rmd", "filename": "rsql.html", "title": "rsql", "engine": "knitr::rmarkdown", "headings": [], "created": "2017-09-24 05:53:02", "modified": "2020-01-08 18:55:16", "commits": 4 } ], "_score": 5.462397997898956, "_indexed": true, "_nocasepkg": "rsql", "_universes": [ "ropenstats", "kenarab" ], "_binaries": [ { "r": "4.7.0", "os": "linux", "version": "0.2.2", "date": "2026-09-23T08:18:14.000Z", "distro": "resolute", "commit": "e89b916a85c6a9c0cefa5c238b0a309a676e8b3a", "fileid": "https://r2.ropensci.org/caeaea9a6f6f1179b606b848aa69c421ac767900adfd4f34bc0d27f666af72b9", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/ropenstats/actions/runs/35835799600" }, { "r": "4.6.1", "os": "linux", "version": "0.2.2", "date": "2026-09-23T08:18:09.000Z", "distro": "resolute", "commit": "e89b916a85c6a9c0cefa5c238b0a309a676e8b3a", "fileid": "https://r2.ropensci.org/c89bc8f23b8b585b12e7e4c5be295e5914d16bbbcde113b57474b114105db584", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/ropenstats/actions/runs/35835799600" }, { "r": "4.5.3", "os": "mac", "version": "0.2.2", "date": "2026-09-23T08:19:04.000Z", "commit": "e89b916a85c6a9c0cefa5c238b0a309a676e8b3a", "fileid": "https://r2.ropensci.org/774c298c986887e7138671e043ddb0fb314e37b67a85ac4f3324cb130fb50436", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/ropenstats/actions/runs/35835799600" }, { "r": "4.6.1", "os": "mac", "version": "0.2.2", "date": "2026-09-23T08:18:35.000Z", "commit": "e89b916a85c6a9c0cefa5c238b0a309a676e8b3a", "fileid": "https://r2.ropensci.org/e79608a3d7dd0a8c3103c524fec5427e94778d5eadbe17fdafedadbbcf25f6e2", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/ropenstats/actions/runs/35835799600" }, { "r": "4.6.0", "os": "wasm", "version": "0.2.2", "date": "2026-09-23T08:18:04.000Z", "commit": "e89b916a85c6a9c0cefa5c238b0a309a676e8b3a", "fileid": "https://r2.ropensci.org/7f6abc7c4936ee58b59c02d20e317ff8f74fe3b9a36beba24851a4e13e961d1b", "status": "success", "buildurl": "https://github.com/r-universe/ropenstats/actions/runs/35835799600" }, { "r": "4.7.0", "os": "win", "version": "0.2.2", "date": "2026-09-23T08:17:07.000Z", "commit": "e89b916a85c6a9c0cefa5c238b0a309a676e8b3a", "fileid": "https://r2.ropensci.org/bfd968cebd1225bd926fe802368039fcb3b5f17e885686eb4e235d2074ba5834", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/ropenstats/actions/runs/35835799600" }, { "r": "4.5.3", "os": "win", "version": "0.2.2", "date": "2026-09-23T08:16:57.000Z", "commit": "e89b916a85c6a9c0cefa5c238b0a309a676e8b3a", "fileid": "https://r2.ropensci.org/5679949fc04d033c7dfaa9efe6c55bd02abcbee070a9e62dc34ee7c883580571", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/ropenstats/actions/runs/35835799600" }, { "r": "4.6.1", "os": "win", "version": "0.2.2", "date": "2026-09-23T08:17:05.000Z", "commit": "e89b916a85c6a9c0cefa5c238b0a309a676e8b3a", "fileid": "https://r2.ropensci.org/06e3b011aaa0212f00bb3596824b5e630c705093ce02862e0d7ba4bf4a83480f", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/ropenstats/actions/runs/35835799600" } ] }