Skip to main content
โ† Back to index page

๐Ÿง‘โ€๐Ÿ’ป Supercharge AQL with SQL Passthrough

Have you ever received JSON data in your dataset and wished you could unnest it right there, without having to go back and modify your data model?

Previously, you'd need to:

  • ๐Ÿ”™ Navigate back to the model
  • ๐Ÿ›  Create a SQL dimension
  • โœ Write custom SQL just to extract fields

Why? Because AQL doesn't yet have built-in support for these database-specific functions (like JSON unnesting).

Now, with SQL Passthrough for AQL, you can do this directly in your dataset! ๐ŸŽ‰

No more back-and-forth โ€” just write AQL and leverage native SQL functions to handle JSON (and much more).

This isnโ€™t limited to JSON unnesting โ€” any database-specific functionality not available in AQL can now be tapped into using passthrough.

๐Ÿ‘‰ How it works: SQL Passthrough functions act as a bridge, letting you call native SQL functions from your underlying database while maintaining type safety inside AQL queries.

That means you can:

  • Extract fields from JSON directly in your dataset
  • Apply database-specific functions (Postgres, BigQuery, MySQL, etc.)
  • Extend the power of AQL without breaking your workflow

For more details, you can visit our public doc about SQL Passthrough