SQLite’s JSON virtual generated columns punch way above their weight. They let you index JSON fields on the fly, no migrations, no whining. Computed like real columns, queryable like real columns, indexable like real columns. But from JSON.
Want flexibility without surrendering speed? This flips the script. Skip the schema stress and still get fast queries.
