Feature: Tracking issue for JSON optimization

[b41sh]

Summary

Optimize JSON read performance by implementing Virtual Column and JSONB binary format

related #5925

Task list

• RFC
• FPGrowth algorithm for statistics
• Extract virtual columns
• Push down JSON key path access
• Tracking: JSONB format #7668

[Xuanwo]

Putting RFC as the first task is excellent!

[haydenflinner]

This will be awesome, it's a great usability feature that it's always felt like is possible but seems to be missing in other db/warehouse/lakehouse solutions!