Re: [Sqlalchemy-tickets] =?utf-8?q?=5Bsqlalchemy=5D_=23120=3A_cant_us?= =?utf-8?q?e_ad-hoc_functions_or_clauses_as_values_with_updates_or_inserts?=

[sqlalchemy <mi...@zz...>]

IzEyMDogY2FudCB1c2UgYWQtaG9jIGZ1bmN0aW9ucyBvciBjbGF1c2VzIGFzIHZhbHVlcyB3aXRo
IHVwZGF0ZXMgb3IgaW5zZXJ0cw0KLS0tLS0tLS0tLS0tLS0tLS0tLS0tKy0tLS0tLS0tLS0tLS0t
LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLQ0KICBSZXBvcnRlcjogIHp6
emVlayAgfCAgICAgICBPd25lcjogIHp6emVlayAgICAgICAgICAgICAgICAgICANCiAgICAgIFR5
cGU6ICBkZWZlY3QgIHwgICAgICBTdGF0dXM6ICByZW9wZW5lZCAgICAgICAgICAgICAgICAgDQog
IFByaW9yaXR5OiAgaGlnaCAgICB8ICAgTWlsZXN0b25lOiAgMC40LjAgICAgICAgICAgICAgICAg
ICAgIA0KIENvbXBvbmVudDogIHNxbCAgICAgfCAgICBTZXZlcml0eTogIHZlcnkgbWFqb3IgLSB1
cCB0byAyIGRheXMNClJlc29sdXRpb246ICAgICAgICAgIHwgICAgS2V5d29yZHM6ICAgICAgICAg
ICAgICAgICAgICAgICAgICAgDQotLS0tLS0tLS0tLS0tLS0tLS0tLS0rLS0tLS0tLS0tLS0tLS0t
LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tDQpDb21tZW50IChieSBlbHZz
dG9uZUBnbWFpbC5jb20pOg0KDQogdGhlICJPTiBVUERBVEUiIHNjaGVtYS1sZXZlbCBrZXl3b3Jk
IGlzIHN1cHBvcnRlZCwgaXRzIHBhcnQgb2YNCiBGb3JlaWduS2V5Q29uc3RyYWludD8sIGlmIHRo
YXRzIHdoYXQgeW91IHdlcmUgbG9va2luZyBmb3IuDQoNCiBBaCwgbm8gSSB3YXMgcmVmZXJyaW5n
IHRvIHRoZSAiT04gVVBEQVRFIiBmb3IgcmVndWxhciBub24tZm9yZWlnbi1rZXkNCiBjb2x1bW5z
IFsxXS4gRS5nOg0KDQoge3t7Q1JFQVRFIFRBQkxFIHQgKHRzIFRJTUVTVEFNUCBERUZBVUxUIENV
UlJFTlRfVElNRVNUQU1QIE9OIFVQREFURQ0KIENVUlJFTlRfVElNRVNUQU1QKTt9fX0NCg0KIEJ1
dCBJIHNlZW0gdG8gaGF2ZSBqdW1wZWQgdGhlIGd1biBoZXJlIGFzIHRoaXMgcGllY2Ugb2Ygc3lu
dGFjdGljIHN1Z2FyDQogc2VlbXMgdG8gYmUgYSBNeVNRTCBmZWF0dXJlIGFuZCBub3QgYXZhaWxh
YmxlIGluIFBvc3RncmVTUUwgKG9yIGFueSBvdGhlcg0KIERCTVM/KSwgd2hlcmUgYW4gZXhwbGlj
aXQgc2VwYXJhdGVseSBkZWZpbmVkIHRyaWdnZXIgaXMgbmVjZXNzYXJ5IGluc3RlYWQuDQoNCiAg
IGlmIHlvdSBhcmUganVzdCBsb29raW5nIHRvIGZpcmUgb2ZmIGEgZnVuY3Rpb24gYXMgcGFydCBv
ZiB0aGUgU0VUIGNsYXVzZQ0KIG9mIGFuIHVwZGF0ZSBzdGF0ZW1lbnQsIHlvdSBjYW4ganVzdCBl
eGVjdXRlIHRoZSBmdW5jdGlvbiBzZXBhcmF0ZWx5IGFuZA0KIHVzZSBpdHMgcmV0dXJuIHZhbHVl
Lg0KDQogWWVzLCBvZiBjb3Vyc2UuIEl0IHdvdWxkIGp1c3QgYmUgbW9yZSBjb252ZW5pZW50IHRv
IG5vdCBoYXZlIHRvIHdvcnJ5DQogYWJvdXQgaXQgYW5kIGxlYXZlIHRoZSB0aW1lc3RhbXBpbmcg
dG8gdGhlIGRhdGFiYXNlIHN5c3RlbS4gQW5kIGFsc28gYQ0KIGxpdHRsZSBzYWZlciBhZ2FpbnN0
IHByb2dyYW1tZXIgZXJyb3IuIEFsc28sIGlmIHRoZSBjbGllbnQgYXBwbGljYXRpb24gaXMNCiBp
biBkaWZmZXJlbnQgdGltZSB6b25lIGl0IHdvdWxkIGhhdmUgdG8gdGFrZSBjYXJlIHRvIGRvIHRp
bWUgem9uZQ0KIGNvbnZlcnNpb24gKGlmIHRpbWVzdGFtcHMgYXJlIHN1cHBvc2VkIHRvIGJlIGlu
IHNlcnZlciB0aW1lIHpvbmUpLCB3aGljaA0KIGlzIGFub3RoZXIgcG9zc2libGUgcG9pbnQgb2Yg
ZXJyb3IgdGhhdCBjb3VsZCBiZSBhdm9pZGVkIGlmIHRoZQ0KIHRpbWVzdGFtcGluZyB3ZXJlIGRv
bmUgdHJhbnNwYXJlbnRseSBvbiB0aGUgZGF0YWJhc2Ugc2VydmVyLg0KDQogICB3aGF0IGV4YWN0
bHkgaXMgdGhlIGZ1bmN0aW9uYWxpdHkgaGVyZSB0aGF0IHlvdSB0b3RhbGx5ICpjYW5ub3QqIGRv
DQogd2l0aG91dCB0aGUgZnVuY3Rpb24gY2FsbCAiaW5saW5lZCIgaW50byB0aGUgdXBkYXRlIHN0
YXRlbWVudCA/IGFyZSB5b3UNCiBjb3JyZWxhdGluZyByb3dzIGZyb20gYSBzZWxlY3QgaW50byB0
aGUgZnVuY3Rpb24gPw0KDQogTm90aGluZyBJIGNhbm5vdCBkbyBhdCBhbGwuIEkgZGlkbid0IHNh
eSBzbyBhbmQgSSBkZWZpbmF0ZWx5IGRpZG4ndCBtZWFuDQogZm9yIGl0IHRvIHNvdW5kIGFzIGlm
IEkgd2FzIGNvbXBsYWluaW5nLCBqdXN0IGZvdW5kIHRoZSB0aWNrZXQgYW5kIHRob3VnaHQNCiBJ
J2QgY2hpbWUgaW4gOikNCg0KIEkgd2FzIGluIHRoZSB3cm9uZyB3aGVuIEkgdGhvdWdodCBQb3N0
Z3JlU1FMIGhhZCB0aGlzIGNhcGFiaWxpdHksIGFuZA0KIHNpbmNlIGl0IHJlcXVpcmVzIGFuIGV4
cGxpY2l0IHRyaWdnZXIgaW4gdGhlIGRhdGFiYXNlIHRvIGdldCB0aGUgYmVoYXZpb3INCiBJIG5v
dyBzZWUgaXQncyBub3QgYSB0YXNrIGZvciBTQSBhdCBhbGwuIEkgd2FzIHRvIGVhZ2VyLg0KDQog
JydCZXN0IHJlZ2FyZHMnJ1tbQlJdXQ0KICcnQXJvbiBTdGFuc3ZpaycnDQoNCi0tIA0KVGlja2V0
IFVSTDogPGh0dHA6Ly93d3cuc3FsYWxjaGVteS5vcmcvdHJhYy90aWNrZXQvMTIwPg0Kc3FsYWxj
aGVteSA8aHR0cDovL2V4YW1wbGUuY29tLz4NCk15IGV4YW1wbGUgcHJvamVjdA==