Simon Binder

I think they should be supported, yes. We call `Pointer.fromFunction` on the same isolate where we send the queries. Did you run into any issues with them on a background...

It's true that that function is obviously broken and throws an assertion error each time. But I don't think that should have much of an impact, since tests pass and...

We don't (yet) support `CASE` from the Dart query builder. Of course, you can use `CASE` expressions in [custom queries](https://moor.simonbinder.eu/docs/using-sql/custom_queries/) or [moor files](https://moor.simonbinder.eu/docs/using-sql/moor_files/). In your case, you're only using the...

I'll need some time to think about a nice solution here. I think I can see a solution where we'd generate old schemas outside of `lib/`, but have some tool...

> it and give it a default value, on migration I get this error. Which error exactly? That SQL statement looks correct to me, and it seems like it should...

Hm, running that exact statement works for me after setting up a table with the same name and inserting some data. Your column definition also looks correct to me. Do...

Thanks for the report. Given that I couldn't reproduce the logic error locally, can you check that you're using `sqlite3_flutter_libs`? If you run this in your database, what version does...

Can you try upgrading to the latest version (`0.5.9` for `sqlite3_flutter_libs`)? Maybe this query is unintentionally relying on a new sqlite3 feature, but I'll also try to reproduce this on...

Hm this also seems to work for me when using version `3.37.2` of sqlite.

> Do you compile it yourself? If yes, then maybe it is possible to set a compiler flag so that this does not happen. Yes, we use a "custom" (some...