Is there a way to group multiple queries together ...

# squarelibraries

[Sean Proctor]

Is there a way to group multiple queries together as a Query in SQLDelight at runtime? I'm trying to add a list of values to a temp table before the query is run. The query is then used in a paging source, so it needs to be a Query.

[alec]

yes:

myQuery {
  INSERT INTO myTable...
  SELECT * FROM myTable...
}

[alec]

instead of myQuery:

[Sean Proctor]

Is it possible to insert an arbitrarily-sized list like that?

[alec]

should be fine

myQuery {
  INSERT INTO myTable VALUES ?;
  SELECT * FROM myTable;
}

[Sean Proctor]

I didn't know that. Thanks!

[Sean Proctor]

Table parameters are not usable in a grouped statement.

[alec]

oh, neat

[alec]

theres probably a good reason for that but i cant recall right now

[Sean Proctor]

I guess it's pretty hard to generate because the following statement also takes some parameters?