New feature : enclose names

[guiled]

Is it possible to think about the name enclosing in SQL?
Mysql can use name
Oracle uses "name"
SQL Server handles names like [this]
...

A good topic :
http://stackoverflow.com/questions/10573922/what-does-the-sql-standard-say-about-usage-of-backtick

[Hywan]

Hello :-),

Here is our position. SQL is a language, with reserved keywords. The user must not use a reserved keywords in its schema, in order to not being in conflict with the SQL language.
Why? Because each DB has its own workaround, and Hoa\Database is not intented to abstract or to fill their oddities. Hoa\Database, for now, contains two things: a DBAL and a query builder. The query builder constructs queries regarding the SQL-2 standard, without any context (specificities of each DB). That's it.

Nevertheless, if a study shows that one of few common patterns/workarounds exist and are simple to implement, we can review our position. Please, motivate it on the mailing-lists or IRC if you think it is needed.

Thoughts?

[osaris]

@Hywan +1

I'm writing SQL queries everyday on MySQL, PostgreSQL, SQL Anywhere and I never enclose my field names because my databases schemas don't include reserved keywords.

[guiled]

The feature is not "allow to use keyword as identifier", but enclose identifiers.
Nevertheless I close this useless issue

Sorry :-/

[Hywan]

@guiled: Why “sorry” :-)? Does enclose identifiers is different as using keywords as identifiers? Maybe we miss something?

[Hywan]

… or, we could enclose names each time, and the symbol would be parameterizable (e.g. setEncloseSymbol). What do you think?

[guiled]

I have made lot of mistake in this issue like "not having talked about it before" and forget to precise my thoughts.
I was thinking of an optional behaviour for enclosing identifiers, not a feature that encloses everything everytime (that is crappy).
So your method is perfect I guess...

[guiled]

This idea is like you purpose so : a method called setEnclosedSymbol($openSymbol, $closeSymbol = null) that will make all identifier (table name, column name, aliases) in a SQL enclosed between symbols.
This thing is mandatory for names that are like "sql reserved keyword", but can be "nice" for other case.

This is not a prior critic feature.

[Hywan]

ping? What is the state of this issue?