Please note currently queries via the API still use the legacy execution
engine. We are rolling out this new engine across all accounts by EOY. This
will be seamlessly deployed and all interfaces including UI and API will
switch over. You can experience the power of this improvement sooner via this
UI toggle.