A data engineering team ingests semi-structured JSON application logs (roughly 2 TB per day) into a Fabric Eventhouse. Analysts need to run ad-hoc exploratory queries that parse nested JSON fields, apply time-based pattern searches over raw text, and compute rolling aggregations across billions of rows with sub-second interactive response times. Which transformation and query engine should the team standardize on for this workload?