Generated columns · Cloudflare D1 docs

Thought the following was interesting to know:

> Generated columns are virtual columns based on properties within raw json objects.

> Indexes over these properties (dramatically) increases performance of queries.

From their dev pages about querying json on https://developers.cloudflare.com/d1/learning/querying-json

> D1’s support for generated columns allows you to create dynamic columns that are generated based on the values of other columns, including extracted or calculated values of JSON data.

> These columns can be queried like any other column, and can have indexes defined on them. If you have JSON data that you frequently query and filter over, creating a generated column and an index can dramatically improve query performance.