[ARROW-10732] [Rust] [DataFusion] Add SQL support for table/relation aliases and compound identifiers

• Type: New Feature
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 3.0.0
• Fix Version/s: 3.0.0
• Component/s: Rust - DataFusion
• Labels: pull-request-available
• External issue URL: https://github.com/apache/arrow/issues/26678
• Assignee: Andy Grove
• Reporter: Andy Grove
• Created: 25/Nov/20 18:26
• Updated: 11/Jan/23 08:15
• Resolved: 08/Dec/20 11:20

Description

We need to support referencing columns in queries using table name and/or alias prefixes so that we can support use cases such as joins between tables that have duplicate column names.

For example:

SELECT t1.id, t1.name, t2.name FROM t1 JOIN t2 ON t1.id = t2.id 

Issue Links

• blocks: ARROW-10761 [Rust] [DataFusion] Add SQL support for referencing fields in structs
• is related to: ARROW-10813 [Rust] [DataFusion] Implement DFSchema
• links to: GitHub Pull Request #8839