qryflow_execute: Execute a parsed qryflow SQL workflow

In qryflow: Execute Multi-Step 'SQL' Workflows

Execute a parsed qryflow SQL workflow

Description

qryflow_execute() takes a parsed workflow object (as returned by qryflow_parse()), executes each chunk (e.g., ⁠@query⁠, ⁠@exec⁠), and collects the results and timing metadata.

This function is used internally by qryflow_run(), but can be called directly in concert with qryflow_parse() if you want to manually control parsing and execution.

Usage

qryflow_execute(x, con, ..., source = NULL)

Arguments

x	A parsed qryflow workflow object, typically created by qryflow_parse()
con	A database connection from DBI::dbConnect()
...	Reserved for future use.
source	Optional; a character string indicating the source SQL to include in metadata.

Value

An object of class qryflow_result, containing executed chunks with results and a meta field that includes timing and source information.

See Also

qryflow_run(), qryflow_parse()

Examples

con <- example_db_connect(mtcars)

filepath <- example_sql_path("mtcars.sql")

parsed <- qryflow_parse(filepath)

executed <- qryflow_execute(parsed, con, source = filepath)

DBI::dbDisconnect(con)

qryflow documentation built on Aug. 8, 2025, 7:39 p.m.