How to alias a table in Laravel Eloquent queries or using Query Builder

Question

Lets say we are using Laravel s query builder    users   DB  table  really long table name              - gt select  really long table name id              - gt get      I m looking for an equivalent to this SQL   really long table name AS short name   This would be especially helpful when I have to type a lot of selects and wheres  or typically I include the alias in the column alias of the select as well  and it get s used in the result array   Without any table aliases there is a lot more typing for me and everything becomes a lot less readable  Can t find the answer in the laravel docs  any ideas

User · Answer

To use aliases on eloquent models modify your code like this:

Item
    ::from( 'items as items_alias' )
    ->join( 'attachments as att', DB::raw( 'att.item_id' ), '=', DB::raw( 'items_alias.id' ) )
    ->select( DB::raw( 'items_alias.*' ) )
    ->get();

This will automatically add table prefix to table names and returns an instance of Items model. not a bare query result. Adding DB::raw prevents laravel from adding table prefixes to aliases.

User · Answer

Same as AMIB answer  for soft delete error  Unknown column  table alias deleted at     just add - gt withTrashed   then handle it yourself like - gt whereRaw  items alias deleted at IS NULL

User · Answer

Here is how one can do it  I will give an example with joining so that it becomes super clear to someone    products   DB  table  products AS pr           - gt leftJoin  product families AS pf    pf id         pr product family id           - gt select  pr id as id    pf name as product family name    pf id as product family id           - gt orderBy  pr id    desc           - gt get      Hope this helps

User · Answer

Laravel supports aliases on tables and columns with AS  Try   users   DB  table  really long table name AS t              - gt select  t id AS uid              - gt get      Let s see it in action with an awesome tinker tool     php artisan tinker  1    Schema  create  really long table name   function  table    table- increments  id          NULL  2    DB  table  really long table name  - insert   id     null       true  3    DB  table  really long table name AS t  - select  t id AS uid  - get       array       0    object stdClass           uid      1

User · Answer

To use in Eloquent  Add on top of your model  protected  table    table name as alias        table name should be exact as in your database     then use in your query like  ModelName  query  - gt select alias id  alias name

User · Answer

You can use less code  writing this        users   DB  table  really long table name          - gt get array  really long table name field very long name as short name       And of course if you want to select more fields  just write a     and add more     users   DB  table  really long table name          - gt get array  really long table name field very long name as short name    really long table name another field as other    and another       This is very practical when you use a joins complex query

[php] How to alias a table in Laravel Eloquent queries (or using Query Builder)?

Examples related to php

Examples related to laravel

Examples related to laravel-4

Examples related to eloquent