.. _2026-08-02-sql-column-alias-parsing_release:

=================================================================================
2026-08-02 - SQL Column Alias Parsing Improved for Rules and Agents
=================================================================================

Release
==================
AgileData.io - Smarter SQL Parsing: Column Aliases Now Handled Correctly

The SQL column parsing layer has been enhanced to correctly handle the ``AS`` keyword when columns are aliased directly in a query. Previously, if a column was written as ``column_name AS alias``, the parser could fail to split the alias correctly or pass it through in a form that caused downstream errors.

The fix correctly identifies and splits aliased columns whether the ``AS`` keyword is written explicitly or the alias is implicit. An alias guard has also been applied to development templates to catch cases where agents pass aliased columns directly, preventing these from reaching the BigQuery execution layer in an unexpected form.

**What's New:**

* Column parser now correctly handles ``AS`` aliases passed directly in SQL
* Aliased columns split correctly regardless of explicit or implicit alias syntax
* Alias guard applied to development templates to protect BigQuery execution

**What this means for you:**

* SQL rules and agent-generated queries that use column aliases work correctly without manual workarounds
* More robust SQL handling when building consume and transformation rules

Last Refreshed
===========================
*Doc Refreshed: 2026-08-02*