So the problem is with dart library sqlite_async.dart [1] and not with sqlite itself.
Kind of a misleading title, TBH.
[1] https://github.com/powersync-ja/sqlite_async.dart
Reference to an HN comment that clarifies this - https://news.ycombinator.com/item?id=39290411