[FEATURE]: Support feature Generated Columns

[TenviLi]

Enhancement Request

Drizzle ORM currently lacks support for SQL generated columns.

• Generated columns · Cloudflare D1 docs
• https://www.sqlite.org/gencol.html

Example1:

Consider a scenario where a JSON object, containing user's profile information, is inserted into a table.

The generated columns feature of SQL can be used to extract the user's age attribute from the JSON and place it in an external column instantly.

This improves query efficiency as we can directly access the age without having to search within the JSON each time.

Example2:

Consider a situation where a Users table contains a JSON array with a list of IDs from an associated table.

It would streamline the process immensely if, during data insertion into Users, the related table could also auto-populate with the IDs from the JSON array.

[denis-ilchishin]

#1471

[L-Mario564]

@AndriiSherman This should be closed.