Santoemma Enrico wrote:
> is there a way to avoid the "as" when building a "from" clause: "from
> mytable as T1"? Oracle, through ODBC, seems not to like it, giving
> something like "sql command unproperly terminated"
Well, there is no way to avoid it in the current version. You could of=20
course try to hack it yourself. However, you might get into trouble if=20
the resulting query uses the same table twice.
There is a known bug with table aliases when using union:
http://sourceforge.net/tracker/index.php?func=3Ddetail&aid=3D961104&group=
_id=3D101095&atid=3D629040
But it doesn't seem like AS would cause an error like that, could it be=20
something else in the query? Did you try using showSql to see the SQL=20
query? Does Oracle not allow table aliases?
> More generally, I believe that an sql wrapper should consider the
> different db syntaxes. This is a common topic to other wrappers too.=20
> Opinions?
Yes, this has been discussed before, and it seems most people agree that=20
it would be useful to tailor the SQL generation to the particular RDBMS=20
being used. This can be tricky with ODBC, since HaskellDB will have=20
trouble figuring out which RDBMS it is talking too. But maybe this could=20
just be another parameter to the connect function.
Another related topic is implementing non-SQL backends, which would be=20
interesting if not just to see how general HaskellDB really is.
/Bj=F6rn
|
