{ "_id": "6a1bf03d1d7bb097a0a227d0", "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-05-31 08:10:14 UTC", "User": "root" }, "Author": "Alejandro Baranek [cre, aut],\nLeonardo Belen [aut]", "MD5sum": "b85c724eaa89039e5dab5925107ce9f2", "_user": "ropenstats", "_type": "src", "_file": "RSQL_0.2.2.tar.gz", "_fileid": "e968cd47a6ccb2e9c29d2d1e058746b22648f863beefb9c0432ba2e7ae77bc41", "_filesize": 170461, "_sha256": "e968cd47a6ccb2e9c29d2d1e058746b22648f863beefb9c0432ba2e7ae77bc41", "_created": "2026-05-31T08:10:14.000Z", "_published": "2026-05-31T08:24:29.805Z", "_distro": "noble", "_jobs": [ { "job": 78711090238, "time": 134, "config": "linux-devel-x86_64", "r": "4.7.0", "check": "OK", "artifact": "7315119027" }, { "job": 78711090254, "time": 130, "config": "linux-release-x86_64", "r": "4.6.0", "check": "OK", "artifact": "7315118629" }, { "job": 78711090233, "time": 197, "config": "macos-oldrel-arm64", "r": "4.5.3", "check": "OK", "artifact": "7315192465" }, { "job": 78711090228, "time": 148, "config": "macos-release-arm64", "r": "4.6.0", "check": "OK", "artifact": "7315179731" }, { "job": 78710937258, "time": 163, "config": "source", "r": "4.6.0", "check": "OK", "artifact": "7315103203" }, { "job": 78711090243, "time": 104, "config": "wasm-release", "r": "4.6.0", "check": "OK", "artifact": "7315115587" }, { "job": 78711090250, "time": 89, "config": "windows-devel", "r": "4.7.0", "check": "OK", "artifact": "7315113734" }, { "job": 78711090265, "time": 90, "config": "windows-oldrel", "r": "4.5.3", "check": "OK", "artifact": "7315114059" }, { "job": 78711090256, "time": 72, "config": "windows-release", "r": "4.6.0", "check": "OK", "artifact": "7315111760" } ], "_buildurl": "https://github.com/r-universe/ropenstats/actions/runs/26707296676", "_status": "success", "_host": "GitHub-Actions", "_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 }, "_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" }, "_downloads": { "count": 316, "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/RSQL" }, "_devurl": "https://github.com/ropenstats/rsql", "_searchresults": 27, "_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/RSQL.html", "manual.pdf" ], "_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.431363764158988, "_indexed": true, "_nocasepkg": "rsql", "_universes": [ "ropenstats", "kenarab" ], "_binaries": [ { "r": "4.7.0", "os": "linux", "version": "0.2.2", "date": "2026-05-31T08:12:30.000Z", "distro": "noble", "commit": "e89b916a85c6a9c0cefa5c238b0a309a676e8b3a", "fileid": "5234e68fc937c90ed62872f90d4680c75f0f1d530c9cac27883215264b6da83c", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/ropenstats/actions/runs/26707296676" }, { "r": "4.6.0", "os": "linux", "version": "0.2.2", "date": "2026-05-31T08:12:27.000Z", "distro": "noble", "commit": "e89b916a85c6a9c0cefa5c238b0a309a676e8b3a", "fileid": "adc24bc4e63f23c0e3e0bddce31700809ec89e2ce914ed069911589de6a3328f", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/ropenstats/actions/runs/26707296676" }, { "r": "4.5.3", "os": "mac", "version": "0.2.2", "date": "2026-05-31T08:23:09.000Z", "commit": "e89b916a85c6a9c0cefa5c238b0a309a676e8b3a", "fileid": "3bfc7a92e4fc44d902872c6a25f4e55e3e5783a3e617ee4c5a4850310bb56166", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/ropenstats/actions/runs/26707296676" }, { "r": "4.6.0", "os": "mac", "version": "0.2.2", "date": "2026-05-31T08:21:20.000Z", "commit": "e89b916a85c6a9c0cefa5c238b0a309a676e8b3a", "fileid": "35556568e2df673afae8583b271aa78e92b65953b9d2abc44c76e3c0ea55fe61", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/ropenstats/actions/runs/26707296676" }, { "r": "4.6.0", "os": "wasm", "version": "0.2.2", "date": "2026-05-31T08:12:20.000Z", "commit": "e89b916a85c6a9c0cefa5c238b0a309a676e8b3a", "fileid": "8392d6d4e8f5592e304fa01805c53b5f301be3d60feccb9e8f0bcd198499c0fa", "status": "success", "buildurl": "https://github.com/r-universe/ropenstats/actions/runs/26707296676" }, { "r": "4.7.0", "os": "win", "version": "0.2.2", "date": "2026-05-31T08:11:39.000Z", "commit": "e89b916a85c6a9c0cefa5c238b0a309a676e8b3a", "fileid": "ece50453b28edaa3dbd87209fc62146d2a55de32a049c93a61da74a2535c4fa5", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/ropenstats/actions/runs/26707296676" }, { "r": "4.5.3", "os": "win", "version": "0.2.2", "date": "2026-05-31T08:11:43.000Z", "commit": "e89b916a85c6a9c0cefa5c238b0a309a676e8b3a", "fileid": "684fdc31662cc6e3eb4f3059e3f88f00a0b58c0acdbed1a41d55c1ef6b64bb3c", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/ropenstats/actions/runs/26707296676" }, { "r": "4.6.0", "os": "win", "version": "0.2.2", "date": "2026-05-31T08:11:25.000Z", "commit": "e89b916a85c6a9c0cefa5c238b0a309a676e8b3a", "fileid": "8879a57ebf64ca86e6c3a98add67493e0228669c073826b47e22d88f8cd6d4f0", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/ropenstats/actions/runs/26707296676" } ] }