Hello All,

Very new to duckdb, but extremely impressed so far!!!

Just curious to see if duckdb stand alone installation currently supports one of the following abilities:

1. create a stored procedure accepting parameter and defining variables
2. execute a series of queries from a .sql file

Problem:
I have the same set of queries, I need to run on a recurring basis to derive a final data set. The files are time relative so it would be nice to pass in the date parameters to be referenced in the query filters when the queries are executed. Looking for a way to either execute the same set of queries passing in variables to be used in query statements or at a minimum executing the SQL statements from a file such as passing the file with SQL statements to parser.

Any support, guidance or insights would be much appreciated.

Best Regards