Looking forward to SQLite 3.38.0, JSON will become default built-in, and new '->' and '->>' JSON operators operators compatible with PostgreSQL and MySQL.

https://sqlite.org/draft/releaselog/3_38_0.html