Objective: Enhance query performance through efficient indexing strategies, possibly without relying on VIRTUAL columns.

Approach:

• Research and implement expression indexes using json_extract() for critical paths in the JSON documents. This method should provide the necessary indexing without the overhead of maintaining VIRTUAL columns.
• Design a flexible indexing strategy that allows for easy addition of indexes based on application needs, possibly through a configuration or initialization script.

• This is partially stubbed out, but not implemented yet.

• While the initial design does not require traditional schema migrations, it's prudent to consider a mechanism for evolving the database setup or indexes as the application grows or changes.
• Implement versioning for the database setup to facilitate smooth transitions and updates in the future.