[Dbix-class] Issue with sql names

[Marc Espie]

On Thu, Dec 07, 2006 at 05:20:36PM +0100, Robert 'phaylon' Sedlacek wrote:
> Marc Espie wrote:
> > The requests generated by DBIx::Class do not quote field names by default.
> > Is there a way to get them quoted ? Even though this generates less readable
> > SQL, this can be useful in some cases...
> 
> It's even in the documentation:
> http://search.cpan.org/dist/DBIx-Class/lib/DBIx/Class/Manual/Cookbook.pod#Setting_quoting_for_the_generated_SQL.

Thanks! next question, is there any way to do that automatically ? I come
from the old DBI, which often knows about the correct quote chars for
the database... I don't quite understand why this is not automatic ?

I assume some dbd back-ends might have issues, but in that case, the storage
could do stuff correctly on at least common db formats, like sqlite or pg... ?