More Generic Moose
It is putter about some more day here in the Moose-Pen
I was puttering about today with my tests and I discovered something funny on some implications of SQL and it is to do with that 'AS' when playing with 'alias'. Now I knew it was an optional 'key-word' according to the SQL standard what I did not know is a number of DBs will syntax error when an optional key-word is used. So this SQLSELECT sys_users.last_name AS last FROM people AS sys_users
is correct to standard there are a number of DBs out there that only this will work
SELECT sys_users.last_name last FROM people sys_users
That makes the above one almost 100% universal that I can tell. I originally wanted that 'AS' in there to make the generated SQL much more readable but I have come to realize that '99.9995%' of the time the end user Database::Accessor will never care what the end SQL is just that it works.