allow table aliases in JOIN queries #3

mojolicious / sql-abstract-pg

:elephant: PostgreSQL features for SQL::Abstract

https://metacpan.org/pod/SQL::Abstract::Pg

Artistic License 2.0

5 stars 3 forks source link

allow table aliases in JOIN queries #3 #5

Open s1037989 opened 1 year ago

s1037989 commented 1 year ago

Summary

JOIN now supports SQL::Abstract -as notation. Moreover, data structures in the JOIN's ON clauses are now supported.

Motivation

From #3, "It's not possible to create table aliases in generated SQL queries. This would be useful for generating queries where a table is JOINed to itself. Especially useful if someone wants to create an ORM based on Mojo::Pg."