A modern programming language that makes developers happier.

kotlinlang

Something unclear to me when using SQLDelight with `generateAsync.set(true)`.  Any call to `driver.executeQuery()` should be migrated to `driver.awaitQuery()` , right?
But this doesn't seem to work with a non-async driver such as the JDBC one on the JVM. For instance I'm doing this:

```driver.awaitQuery(
  null,
  "PRAGMA $versionPragma",
  { cursor -&gt;
    // The cursor is already closed here
    if (cursor.next().await()) {
      cursor.getLong(0)
    } else {
      null
    }
  },
  0
) ```
using the debugger I can see that my lambda is called after the statement has already been closed which obviously cannot work.

I must be missing something obvious? :thinking_face:

Other extensions like `awaitAsOneOrNull()` seem to work as expected.

Async generation is only for async drivers

Interesting!

Is there an idiomatic way to execute arbitrary queries that works for both sync and async?

```  Query(
      0, 
      arrayOf(), 
      driver, 
      "", 
      "", 
      "my query") { cursor ->
     // ...
  }.awaitAsList()```
This works, but seems a bit awkward maybe?