ossipesonen/elixir

Zero dependency PHP Query Builder forked from Doctrine DBAL QueryBuilder

elixir's Issues

Removing forceful aliases

Currently the library forces alias use for joins.

$qb->select('parent_alias.id', 'alias_for_joined_table.name')
->from('parent', 'parent_alias')
->innerJoin('parent_alias', 'joined_table', 'alias_for_joined_table', 'alias_for_joined_table.parent_id = parent_alias.id');

This creates an SQL query:

SELECT parent_alias.id, alias_for_joined_table.name FROM parent parent_alias INNER JOIN joined_table alias_for_joined_table ON alias_for_joined_table.parent_id = parent_alias.id

This becomes cumbersome as it's sometimes easier to build a query without the need to create an alias for every table, but instead reference the table name.

The code should ignore alias use in cases where the alias is passed as:

• Real name
• Empty string
• NULL value
• Omitted (from)

In these cases aliases should be dropped. Example:

$qb->select('parent_alias.id', 'alias_for_joined_table.name')
->from('parent')
->innerJoin('parent', 'joined_table', null, 'joined_table.parent_id = parent.id');

Resulting in:

SELECT parent.id, joined_table.name FROM parent INNER JOIN joined_table ON joined_table.parent_id = parent.id