Robin Moffatt • 2/27/2025

DuckDB tricks - renaming fields in a SELECT * across tables

This technical article explains a common problem in DuckDB where SELECT * across joined tables with overlapping column names creates ambiguity. It demonstrates the solution using DuckDB's COLUMNS expression to automatically prefix column names (e.g., t1_\0) from specific tables, providing a clean and reusable alternative to manually aliasing each column. It also mentions newer prefix alias syntax introduced in DuckDB 1.20.

0 comments

#database #sql #Query Optimization