{ "_id": "6a26d75524555f66ed5243a9", "Package": "qryflow", "Title": "Execute Multi-Step 'SQL' Workflows", "Version": "0.4.0", "Authors@R": "person(\"Christian\", \"Million\", , \"christianmillion93@gmail.com\", role = c(\"aut\", \"cre\", \"cph\"))", "Description": "Execute multi-step 'SQL' workflows by leveraging specially\nformatted comments to define and control execution. This\nenables users to mix queries, commands, and metadata within a\nsingle script. Results are returned as named objects for use in\ndownstream workflows.", "License": "MIT + file LICENSE", "Encoding": "UTF-8", "Roxygen": "list(markdown = TRUE)", "RoxygenNote": "7.3.3", "Config/testthat/edition": "3", "VignetteBuilder": "knitr", "URL": "https://christian-million.github.io/qryflow/,\nhttps://github.com/christian-million/qryflow/", "BugReports": "https://github.com/christian-million/qryflow/issues", "Repository": "https://christian-million.r-universe.dev", "Date/Publication": "2026-06-08 14:39:38 UTC", "RemoteUrl": "https://github.com/christian-million/qryflow", "RemoteRef": "HEAD", "RemoteSha": "09cf519f892853e70f11ed6dfae01e105e6d60e6", "NeedsCompilation": "no", "Packaged": { "Date": "2026-06-08 14:50:05 UTC", "User": "root" }, "Author": "Christian Million [aut, cre, cph]", "Maintainer": "Christian Million ", "MD5sum": "5c495771505f40201a382e5dd70522bd", "_user": "christian-million", "_type": "src", "_file": "qryflow_0.4.0.tar.gz", "_fileid": "4ea78cde810bedb75dba43fa67ac1ce5ac103af19624a78f1eca26f4a947a5b0", "_filesize": 168500, "_sha256": "4ea78cde810bedb75dba43fa67ac1ce5ac103af19624a78f1eca26f4a947a5b0", "_created": "2026-06-08T14:50:05.000Z", "_published": "2026-06-08T14:53:09.875Z", "_distro": "noble", "_jobs": [ { "job": 80123809076, "time": 152, "config": "linux-devel-x86_64", "r": "4.7.0", "check": "OK", "artifact": "7483884030" }, { "job": 80123808992, "time": 122, "config": "linux-release-x86_64", "r": "4.6.0", "check": "OK", "artifact": "7483869307" }, { "job": 80123809111, "time": 89, "config": "macos-oldrel-arm64", "r": "4.5.3", "check": "OK", "artifact": "7483851086" }, { "job": 80123808996, "time": 70, "config": "macos-release-arm64", "r": "4.6.0", "check": "OK", "artifact": "7483844937" }, { "job": 80123074832, "time": 195, "config": "source", "r": "4.6.0", "check": "OK", "artifact": "7483811405" }, { "job": 80123808985, "time": 101, "config": "wasm-release", "r": "4.6.0", "check": "OK", "artifact": "7483859720" }, { "job": 80123809017, "time": 79, "config": "windows-devel", "r": "4.7.0", "check": "OK", "artifact": "7483849116" }, { "job": 80123809019, "time": 75, "config": "windows-oldrel", "r": "4.5.3", "check": "OK", "artifact": "7483847037" }, { "job": 80123808998, "time": 93, "config": "windows-release", "r": "4.6.0", "check": "OK", "artifact": "7483855629" } ], "_buildurl": "https://github.com/r-universe/christian-million/actions/runs/27145784293", "_status": "success", "_host": "GitHub-Actions", "_upstream": "https://github.com/christian-million/qryflow", "_commit": { "id": "09cf519f892853e70f11ed6dfae01e105e6d60e6", "author": "Christian Million ", "committer": "Christian Million ", "message": "pkgdown yaml\n", "time": 1780929578 }, "_maintainer": { "name": "Christian Million", "email": "christianmillion93@gmail.com", "login": "christian-million", "description": "Looking to collaborate and contribute to R / Python projects.", "uuid": 34721595 }, "_registered": true, "_dependencies": [ { "package": "R", "version": ">= 4.1.0", "role": "Depends" }, { "package": "DBI", "role": "Imports" }, { "package": "knitr", "role": "Suggests" }, { "package": "rmarkdown", "role": "Suggests" }, { "package": "RSQLite", "role": "Suggests" }, { "package": "testthat", "version": ">= 3.0.0", "role": "Suggests" } ], "_owner": "christian-million", "_selfowned": true, "_usedby": 0, "_updates": [ { "week": "2025-29", "n": 5 }, { "week": "2026-06", "n": 5 }, { "week": "2026-08", "n": 2 }, { "week": "2026-09", "n": 2 }, { "week": "2026-10", "n": 3 }, { "week": "2026-11", "n": 1 }, { "week": "2026-23", "n": 1 }, { "week": "2026-24", "n": 3 } ], "_tags": [ { "name": "v0.1.0", "date": "2025-07-18" }, { "name": "v0.2.0", "date": "2026-02-05" }, { "name": "v0.4.0", "date": "2026-06-07" } ], "_stars": 4, "_contributors": [ { "user": "christian-million", "count": 51, "uuid": 34721595 } ], "_userbio": { "uuid": 34721595, "type": "user", "name": "Christian Million", "description": "Looking to collaborate and contribute to R / Python projects." }, "_downloads": { "count": 104, "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/qryflow" }, "_devurl": "https://github.com/christian-million/qryflow", "_pkgdown": "https://christian-million.github.io/qryflow/", "_searchresults": 5, "_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/qryflow.html", "extra/readme.html", "extra/readme.md", "manual.pdf" ], "_homeurl": "https://github.com/christian-million/qryflow", "_realowner": "christian-million", "_cranurl": true, "_releases": [ { "version": "0.1.0", "date": "2025-07-18" }, { "version": "0.2.0", "date": "2026-02-05" }, { "version": "0.4.0", "date": "2026-06-08" } ], "_exports": [ "collapse_sql_lines", "example_db_connect", "example_sql_path", "extract_all_tags", "is_tag_line", "ls_qryflow_types", "new_qryflow_chunk", "qryflow", "qryflow_execute", "qryflow_handler_exists", "qryflow_meta", "qryflow_parse", "qryflow_results", "qryflow_run", "read_sql_lines", "register_qryflow_type", "subset_tags", "validate_qryflow_handler" ], "_help": [ { "page": "collapse_sql_lines", "title": "Collapse SQL lines into single character", "topics": [ "collapse_sql_lines" ] }, { "page": "example_db_connect", "title": "Create an example in-memory database", "topics": [ "example_db_connect" ] }, { "page": "example_sql_path", "title": "Get path to qryflow example SQL scripts", "topics": [ "example_sql_path" ] }, { "page": "extract_all_tags", "title": "Extract tagged metadata from a SQL chunk", "topics": [ "extract_all_tags", "subset_tags" ] }, { "page": "is_tag_line", "title": "Detect the presence of a properly structured tagline", "topics": [ "is_tag_line" ] }, { "page": "ls_qryflow_types", "title": "List currently registered chunk types", "topics": [ "ls_qryflow_types" ] }, { "page": "new_qryflow_chunk", "title": "Create an instance of the 'qryflow_chunk' class", "topics": [ "new_qryflow_chunk" ] }, { "page": "qryflow", "title": "Run a multi-step SQL workflow and return query results", "topics": [ "qryflow" ] }, { "page": "qryflow_execute", "title": "Execute a parsed qryflow SQL workflow", "topics": [ "qryflow_execute" ] }, { "page": "qryflow_handler_exists", "title": "Check existence of a given handler in the registry", "topics": [ "qryflow_handler_exists" ] }, { "page": "qryflow_meta", "title": "Extract metadata from qryflow objects", "topics": [ "qryflow_meta" ] }, { "page": "qryflow_parse", "title": "Parse a SQL workflow into tagged chunks", "topics": [ "qryflow_parse" ] }, { "page": "qryflow_results", "title": "Extract results from a 'qryflow_workflow' object", "topics": [ "qryflow_results" ] }, { "page": "qryflow_run", "title": "Parse and execute a tagged SQL workflow", "topics": [ "qryflow_run" ] }, { "page": "read_sql_lines", "title": "Standardizes lines read from string, character vector, or file", "topics": [ "read_sql_lines" ] }, { "page": "register_qryflow_type", "title": "Register custom chunk types", "topics": [ "register_qryflow_type" ] }, { "page": "validate_qryflow_handler", "title": "Ensure correct handler structure", "topics": [ "validate_qryflow_handler" ] } ], "_readme": "https://github.com/christian-million/qryflow/raw/HEAD/README.md", "_rundeps": [ "DBI" ], "_vignettes": [ { "source": "extend-qryflow.Rmd", "filename": "extend-qryflow.html", "title": "Extending qryflow Functionality", "engine": "knitr::rmarkdown", "headings": [ "Overview", "Big Picture: How qryflow Works", "Creating Handlers", "Validate the Handler", "How the Registry Works", "Toy Example: Create query-send Chunk Type" ], "created": "2025-07-15 04:45:32", "modified": "2026-03-05 14:56:30", "commits": 6 }, { "source": "qryflow.Rmd", "filename": "qryflow.html", "title": "Getting Started with qryflow", "engine": "knitr::rmarkdown", "headings": [ "What is qryflow?", "Basic usage", "Defining a Chunk", "Tags and Aliases", "Important Tags", "Type Identification", "Passing Additional Tags", "Important Arguments", "on_error", "verbose", "simplify", "The Core API", "qryflow_run() and qryflow_results()", "qryflow_parse() and qryflow_execute()", "Metadata", "Summary", "Examples" ], "created": "2025-07-15 04:45:32", "modified": "2026-03-01 21:41:32", "commits": 3 } ], "_score": 5.505149978319906, "_indexed": true, "_nocasepkg": "qryflow", "_universes": [ "christian-million" ], "_previous": "0.3.0.9000", "_binaries": [ { "r": "4.7.0", "os": "linux", "version": "0.4.0", "date": "2026-06-08T14:52:38.000Z", "distro": "noble", "commit": "09cf519f892853e70f11ed6dfae01e105e6d60e6", "fileid": "8409ac8f4ea07c2f465f2ad52f645f15d90b948bb3a8365420cd8c3000077bb4", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/christian-million/actions/runs/27145784293" }, { "r": "4.6.0", "os": "linux", "version": "0.4.0", "date": "2026-06-08T14:52:06.000Z", "distro": "noble", "commit": "09cf519f892853e70f11ed6dfae01e105e6d60e6", "fileid": "ecef2da5930912c782d6dc2a3cabd7aefd8cfda39128962f3dd120f4c4e24707", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/christian-million/actions/runs/27145784293" }, { "r": "4.5.3", "os": "mac", "version": "0.4.0", "date": "2026-06-08T14:51:31.000Z", "commit": "09cf519f892853e70f11ed6dfae01e105e6d60e6", "fileid": "3f6d2820608bfa463c0c24fa413f8da48d62513737ae25ffafa2b4b5b37ced77", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/christian-million/actions/runs/27145784293" }, { "r": "4.6.0", "os": "mac", "version": "0.4.0", "date": "2026-06-08T14:51:21.000Z", "commit": "09cf519f892853e70f11ed6dfae01e105e6d60e6", "fileid": "2d121ac91d3e94dbdc82b62eaec4dd4d16f611a1423f951c3a1b21751f03c624", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/christian-million/actions/runs/27145784293" }, { "r": "4.6.0", "os": "wasm", "version": "0.4.0", "date": "2026-06-08T14:52:01.000Z", "commit": "09cf519f892853e70f11ed6dfae01e105e6d60e6", "fileid": "eb54afb1b91ad1bef8bce874453ba044b4d870de8500d19323d6e8ce8cc8b19f", "status": "success", "buildurl": "https://github.com/r-universe/christian-million/actions/runs/27145784293" }, { "r": "4.7.0", "os": "win", "version": "0.4.0", "date": "2026-06-08T14:51:20.000Z", "commit": "09cf519f892853e70f11ed6dfae01e105e6d60e6", "fileid": "59632611332718488033a9b74a671c26336ee1743b66910e52bb4ec1c7d55297", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/christian-million/actions/runs/27145784293" }, { "r": "4.5.3", "os": "win", "version": "0.4.0", "date": "2026-06-08T14:51:16.000Z", "commit": "09cf519f892853e70f11ed6dfae01e105e6d60e6", "fileid": "cb37264e9e52ad29091df592e30a18cc4b87b4b11adef1776600e02f5a310840", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/christian-million/actions/runs/27145784293" }, { "r": "4.6.0", "os": "win", "version": "0.4.0", "date": "2026-06-08T14:51:32.000Z", "commit": "09cf519f892853e70f11ed6dfae01e105e6d60e6", "fileid": "7abf5e256cadc7b487a5a5f082722556173c766a5729fbacbade5bf197a47596", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/christian-million/actions/runs/27145784293" } ] }