Simon Binder

I see, I think this is because we don't properly support resolving Dart expressions in the plugin yet. I'll take a look at how that might be done.

I've fixed this in 230a18abdc1fa3eda461a7093f8f33fb62547440, but I still need to investigate a potential performance impact of that approach.

You can write a custom [`DriftWebStorage`](https://pub.dev/documentation/drift/latest/drift.web/DriftWebStorage-class.html) implementation to define how to store data. Then, you can use `WebDatabase.withStorage()` and your custom storage implementation to rely on the Chrome filesystem APIs....

I see that you've also commented on the other issue for this, and I think that explains most of the the steps. If you have an existing sqlite3 database file,...

After https://github.com/Dart-Code/Dart-Code/pull/2203 gets released (might take some time, the underlying apis are still experimental in VS Code) moor will be able to contribute its own highlighting. You can already use...

The best way to use this would be a query in a [moor file](https://moor.simonbinder.eu/docs/using-sql/moor_files/). You'll also need to enable the json1 extension in your [builder options](https://moor.simonbinder.eu/docs/advanced-features/builder_options/#available-extensions). You could do something...

At the moment this can't be done in Dart. `json_extract` essentially returns a new table, which is not supported by the Dart api at the moment. Supporting table-valued functions in...

Using moor files would probably be the best approach, but you can also separate your Dart table classes across multiple files. It's true that most or all of the the...

FWIW you can already implement the structure like this and just import your table files into `app_database.dart` (just use regular Dart imports and reference the classes in `@DriftDatabase`). If you...

I'm not sure what `resetDatabase` is doing, but imagine that you could simply delete the local database file and re-open. Are you using a `FlutterQueryExecutor` or `VmDatabase`?