I use POSTGRES SQL. But I see that the POSTGRES SQL SINTAXES is not implemented.
SELECT coalesce(ean.codean) ean FROM EAN
There is an error: I think taht DB wants "as"
For me it is important that all my QUERY to be used "how are now"
Currently DBxtra requires you to use the AS keyword to specify column alias, so the syntax you use (column_name alias) is not supported right now.
As a side note, we recommend you to use the AS keyword before column alias as it may lead to ambiguity according to the PostgreSQL documentation (http://www.postgresql.org/docs/9.1/static/sql-select.html):
"In the SQL standard, the optional key word AS can be omitted before an output column name whenever the new column name is a valid column name (that is, not the same as any reserved keyword).
PostgreSQL is slightly more restrictive: AS is required if the new column name matches any keyword at all, reserved or not. Recommended practice is to use AS or double-quote output column names, to prevent any possible conflict against future keyword additions."