Feature: Tracking issue for JSON optimization

[b41sh]

Summary

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

related #5925

Task list

• [x] RFC
• [ ] FPGrowth algorithm for statistics
• [ ] Extract virtual columns
• [ ] Push down JSON key path access
• [x] https://github.com/datafuselabs/databend/issues/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!