v1.0.36-nightly

What's Changed

Exciting New Features ✨

• feat(query): table function generate_series & range by @jun0315 in #10697
• feat: improve window frame computation. by @RinChanNOWWW in #10791

Thoughtful Bug Fix 🔧

• fix(ci): tmp disable some oom tpch queries for benchmark by @everpcpc in #10780
• fix: Allow PUBLIC role show databases / tables / columns by @flaneur2020 in #10788
• fix: right join oom by @xudong963 in #10782
• fix(storage): compact limit return incorrect row number by @zhyass in #10743
• fix(FlightSQL): records/size in FlightInfo should be -1 when unknown. by @youngsofun in #10793

Code Refactor 🎉

• refactor(settings): refactor default, global, session settings by @zhang2014 in #10757

Documentation 📔

• docs: SHOW COLUMNS by @soyeric128 in #10779
• docs: add PIVOT/UNPIVOT by @BohuTANG in #10781

Others 📒

• chore(FlightSQL): log all req to unimplemented API. by @youngsofun in #10784
• chore(openai): change openai from async to sync by @BohuTANG in #10785

Full Changelog: v1.0.35-nightly...v1.0.36-nightly