Stored procedure

[vanillajonathan]

Maybe PRQL could support executing stored procedures?

Maybe there could be a "execute" keyword in PRQL so that:

execute SelectAllCustomers

Would transform into the SQL:

EXEC SelectAllCustomers

[max-sixty]

Because PRQL only issues one SQL query per PRQL query, and we target analytical use cases — this probably isn't high on the list.

Happy to leave this open to collect ideas though!

[vanillajonathan]

The stored procedure could return a value that could be used in a analytical use case.

let foo = execute usp_get_foo
from customers
filter status == foo