Execute sql strings with multiple statements

[kilianmh]

In the psql cli we can execute two statements in one go. E.g.

CREATE TABLE test_table (user_id INTEGER NOT NULL PRIMARY KEY , user_name VARCHAR(256) NOT NULL);

CREATE INDEX idx_test_table_user_name
ON test_table (user_name);

Right now trying this with pomo:execute or pomo:query results in an error.

Do you think these macros could/should handle sql strings with multiple statements as well?
This would also allow to add more slots to dao class (e.g. col-index, col-comment).

I can help with the implementation if it helps.

[sabracrolleton]

I am a bit time constrained right now, so would be happy if you took a first look.

[kilianmh]

I guess we have to split the queries at one point with parse-queries to support multiple statements.

As I see it there are basically 3 options (probably there are more):

1. Add an arg to query e.g. :multiple-statements
   When this arg is present, the query will be split.
   (not sure how to implement this)
2. Split the query within an existing functions.
   Options are e.g. query (macro-function), exec-query (function), send-query (function)
   The performance will be slightly worse since parse-queries would be performed in all queries.
3. Introduce new macros/functions (e.g. queries, execute-queries, orsend-queries) that split the query with parse-queries and call the existing functions.
   Downside is that we have to export more exported symbols and users need to know about them as well.

Which options sounds best to you, or you got another idea?

[sabracrolleton]

My initial preference would be #3 (I like singular and plural, but that is just me).

Probably need an arg for the user to decide if everything is wrapped in a single transaction or commits each separately.

Would we get back parameterization that we do not have in execute-file?