Support sync read for the page cache decode improvement.

[zhuqi-lucas]

Is your feature request related to a problem or challenge? Please describe what you are trying to do.

We support async read for page cache, details:
#6921

We also need to support sync read, so i create this ticket.

Describe the solution you'd like

Describe alternatives you've considered

Additional context

[alamb]

Thank you @zhuqi-lucas -- I also added this to the ticket where we are organizing the work:

• Parquet decoder / decoded predicate / page / results Cache #7363