Pymssql and python-sql error: alias not allowed in update insert query

Support Developer
1

Using the module python-sql with pymssql give an error in case of insert or update query.

there is any way to disable alias for for update and insert ?

Thanks in advance
Matteo

2

python-sql: 66e664b07bd3 remove the usage of alias for the columns.
What is exactly the problem?

3

I see MSSQL does not support the as in INSERT INTO ... AS ....
I guess it should be possible to add an option to the AliasManager to use the table name as alias and than to skip the AS ... part in the query.
This could be activated by a flavor option.

4

Dear Ced,
thanks for the info, I’m not able to set the Flavor

from sql import *
from sql.aggregate import *
from sql.conditionals import *
r_lav_order = Table('RigheOrdineLavorazioneVersoLantek')
i=r_lav_order.insert()
i
<sql.Insert object at 0x7f3fcfc77b30>
tuple(i)
('INSERT INTO "RigheOrdineLavorazioneVersoLantek" AS "a" DEFAULT VALUES', ())
Flavor.set(Flavor(no_as=True))
tuple(i)
('INSERT INTO "RigheOrdineLavorazioneVersoLantek" AS "a" DEFAULT VALUES', ())

and could you give me some advice on how to

option to the AliasManager to use the table name as alias

really thanks for your time

5

What I talked does not exist. There is no flavor for that.
The no_as flavor is for Oracle which does not support the keyword AS when define an alias.