ζ ./spirit --host="127.0.0.1:8033" --username="tsandbox" --password="msandbox" \
--database="test_spirit" \
--statement="ALTER TABLE json_table ADD COLUMN price DECIMAL(10,2) GENERATED ALWAYS AS (JSON_EXTRACT(metadata, '$.price')), ADD INDEX idx_price_category ((JSON_EXTRACT(metadata, '$.category'), JSON_EXTRACT(metadata, '$.price')))"
spirit: error: could not parse SQL statement: ALTER TABLE json_table ADD COLUMN price DECIMAL(10,2) GENERATED ALWAYS AS (JSON_EXTRACT(metadata, '$.price')), ADD INDEX idx_price_category ((JSON_EXTRACT(metadata, '$.category'), JSON_EXTRACT(metadata, '$.price')))
Example below: