How do I execute stored procedures (SQL) in Appsmith

How do I do X?
1

We could use the EXEC statement directly inside queries to execute stored procedures inside a SQL DB.

EXEC ProcName @var1 = val1, @var2 = val2