Execute Multi-Step 'SQL' Workflows
Collapse SQL lines into single character
Create an example in-memory database
Get path to qryflow example SQL scripts
Extract tagged metadata from a SQL chunk
Detect the presence of a properly structured tagline
List currently registered chunk types
Create an instance of the qryflow_chunk class
Access the default qryflow chunk type
Execute a parsed qryflow SQL workflow
Check existence of a given handler in the registry
Parse a SQL workflow into tagged chunks
Check existence of a given parser in the registry
Extract results from a qryflow_workflow object
Parse and execute a tagged SQL workflow
Run a multi-step SQL workflow and return query results
Standardizes lines read from string, character vector, or file
Register custom chunk types
Ensure correct handler structure
Ensure correct parser structure
Execute multi-step 'SQL' workflows by leveraging specially formatted comments to define and control execution. This enables users to mix queries, commands, and metadata within a single script. Results are returned as named objects for use in downstream workflows.
Useful links