The table alias is currently forced to lowercase, which limits flexibility.

[mean-cj]

Hello

Would it be possible to remove this restriction force table alias to strtolower() ?

pecee-pixie/src/Pecee/Pixie/QueryBuilder/QueryBuilderHandler.php

Line 701 in 1bbfcdc

$this->statements['aliases'][$table] = \strtolower($alias);

pecee-pixie/src/Pecee/Pixie/QueryBuilder/Adapters/Sqlserver.php

Line 78 in 1bbfcdc

$t = sprintf('%s AS %s', $table, strtolower($prefix));

pecee-pixie/src/Pecee/Pixie/QueryBuilder/Adapters/BaseAdapter.php

Line 361 in 1bbfcdc

return sprintf('%s AS %s', $this->wrapSanitizer($table), $this->wrapSanitizer(strtolower($this->aliasPrefix)));

An example where forcing aliases to be lowercase makes it unusable.

DB::table(['service_type_ssl' => 'tableS'])
  ->select([
    'O.OrderID',
    'O.CustomerID',
    'O.ServiceName',

    'tableS.ServiceStatus',
    'tableS.OrderName',
  ])
  ->leftJoin(['service_order', 'O'], 'O.OrderID', '=', 'tableS.OrderID')
  ->first()

Thank you.