[Dbix-class] How do I get DBIx::Class to quote User table and user collum in SQL Server ?

I am trying to use DBIx Autorization function, I have a table named User, and collumn named user since user is a reserved word, it always get error, I have added the quote_char, name_sep in the connection string but still fail. how can I make sure the generated SQL has the User been quoted ? like

[Dbix-class] DBIx::Class::Helpers -- UNION query with mixed column names

Looking at the example here: http://search.cpan.org/~frew/DBIx-Class-Helpers-2.017000/lib/DBIx/Class/Helper/ResultSet/SetOperations.pm#DESCRIPTION This works because the column names are the same. Notice how both tables use id as the key. my $rs1 = $schema-resultset('Album')-search({

RE: [Dbix-class] How do I get DBIx::Class to quote User table and user collum in SQL Server ?

Hi Hugh You seem to be putting quote_char and name_sep into their own hash ref. You should have them directly in the connect_info hash ref: connect_info = { dsn = 'dbi:ODBC:driver={SQL Server};server=.;', user = '...', password = .', LongTruncOk=1,