CRUD: custom table alias

12-11-2018
The orm asigns a letter in alphabeticall order as a table alias to each join that needs to generate but it is possible to assing a custom alias. Knowing in advance the alias allows for example to call functions like this: ```javascript { name: "idClient", type: "lookup", refTable: "client", refDesc: "name", cascadeDelete: true, alias: "cc", sqlExpression: "CONCAT_WS(', ', cc.lastName, cc.name)", label: "@@Cliente" } ``` This generates: ```sql SELECT CONCAT_WS(cc.lastName, cc.name) AS clientName FROM ... AS a LEFT JOIN amura_crm_client AS cc ON a.idClient = cc.id ```
CRUD Backend