sqlalchemy-tickets

[Sqlalchemy-tickets] =?utf-8?q?=5Bsqlalchemy=5D_=23144=3A_Calculated_columns_in_select_=28and_?= =?utf-8?q?where=29_not_respecting_brackets?=

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

IzE0NDogQ2FsY3VsYXRlZCBjb2x1bW5zIGluIHNlbGVjdCAoYW5kIHdoZXJlKSBub3QgcmVzcGVj
dGluZyBicmFja2V0cw0KLS0tLS0tLS0tLS0tLS0tLS0tLS0tLSstLS0tLS0tLS0tLS0tLS0tLS0t
LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLQ0KIFJlcG9ydGVyOiAgcnRsICAgICAg
IHwgICAgICAgT3duZXI6ICB6enplZWsNCiAgICAgVHlwZTogIGRlZmVjdCAgICB8ICAgICAgU3Rh
dHVzOiAgbmV3ICAgDQogUHJpb3JpdHk6ICBjcml0aWNhbCAgfCAgIE1pbGVzdG9uZTogICAgICAg
IA0KQ29tcG9uZW50OiAgc3FsICAgICAgIHwgICAgIFZlcnNpb246ICAgICAgICANCiBLZXl3b3Jk
czogICAgICAgICAgICB8ICANCi0tLS0tLS0tLS0tLS0tLS0tLS0tLS0rLS0tLS0tLS0tLS0tLS0t
LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0NCldoZW4gcmV0dXJuaW5nIGNh
bGN1bGF0ZWQgY29sdW1ucyB0aGUgYnJhY2tldHMgYXJlIGJlaW5nIGlnbm9yZWQsIHdpdGggdGhl
DQogcmVzdWx0aW5nIG1hdGggYmVpbmcgaW5jb3JyZWN0LCBlLmcuIHRoZSBmb2xsb3dpbmcgdGVz
dCBpcyByZXR1cm5pbmcNCiAiU0VMRUNUIHZhbHVlcy5pZCwgdmFsdWVzLnZhbDIgLSB2YWx1ZXMu
dmFsMSAvIHZhbHVlcy52YWwxIEZST00gdmFsdWVzIg0KIGkuZS4gbWlzc2luZyBhbnkgYnJhY2tl
dHMgYW5kIGEgc2ltaWxhciBwcm9ibGVtIGV4aXN0cyBpbiB0aGUgV0hFUkUNCiBjbGF1c2UuDQoN
Cg0KIHt7ew0KIGRlZiB0ZXN0Y2FsY3VsYXRlZGNvbHVtbnMoc2VsZik6DQogICAgIHZhbHVlX3Ri
bCA9IHRhYmxlKCd2YWx1ZXMnLA0KICAgICAgICAgQ29sdW1uKCdpZCcsIEludGVnZXIpLA0KICAg
ICAgICAgQ29sdW1uKCd2YWwxJywgRmxvYXQpLA0KICAgICAgICAgQ29sdW1uKCd2YWwyJywgRmxv
YXQpLA0KICAgICApDQoNCiAgICAgc2VsZi5ydW50ZXN0KA0KICAgICAgICAgc2VsZWN0KFt2YWx1
ZV90YmwuYy5pZCwgKHZhbHVlX3RibC5jLnZhbDIgLQ0KIHZhbHVlX3RibC5jLnZhbDEpL3ZhbHVl
X3RibC5jLnZhbDFdKSwNCiAgICAgICAgICJTRUxFQ1QgdmFsdWVzLmlkLCAodmFsdWVzLnZhbDIg
LSB2YWx1ZXMudmFsMSkgLyB2YWx1ZXMudmFsMSBGUk9NDQogdmFsdWVzIg0KICAgICApDQoNCiAg
ICAgc2VsZi5ydW50ZXN0KA0KICAgICAgICAgc2VsZWN0KFt2YWx1ZV90YmwuYy5pZF0sICh2YWx1
ZV90YmwuYy52YWwyIC0NCiB2YWx1ZV90YmwuYy52YWwxKS92YWx1ZV90YmwuYy52YWwxID4gMi4w
KSwNCiAgICAgICAgICJTRUxFQ1QgdmFsdWVzLmlkIEZST00gdmFsdWVzIFdIRVJFICh2YWx1ZXMu
dmFsMiAtIHZhbHVlcy52YWwxKSAvDQogdmFsdWVzLnZhbDEgPiA6bGl0ZXJhbCINCiAgICAgKQ0K
IH19fQ0KDQotLSANClRpY2tldCBVUkw6IDxodHRwOi8vd3d3LnNxbGFsY2hlbXkub3JnL3RyYWMv
dGlja2V0LzE0ND4NCnNxbGFsY2hlbXkgPGh0dHA6Ly9leGFtcGxlLmNvbS8+DQpNeSBleGFtcGxl
IHByb2plY3Q=

[Sqlalchemy-tickets] =?utf-8?q?Re=3A_=5Bsqlalchemy=5D_=23144=3A_Calculated_columns_in_select_?= =?utf-8?q?=28and_where=29_not_respecting_brackets?=

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

IzE0NDogQ2FsY3VsYXRlZCBjb2x1bW5zIGluIHNlbGVjdCAoYW5kIHdoZXJlKSBub3QgcmVzcGVj
dGluZyBicmFja2V0cw0KLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0rLS0tLS0tLS0tLS0tLS0tLS0t
LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLQ0KICBSZXBvcnRlcjogIHJ0bCAgICAg
ICB8ICAgICAgIE93bmVyOiAgenp6ZWVrDQogICAgICBUeXBlOiAgZGVmZWN0ICAgIHwgICAgICBT
dGF0dXM6ICBjbG9zZWQNCiAgUHJpb3JpdHk6ICBjcml0aWNhbCAgfCAgIE1pbGVzdG9uZTogICAg
ICAgIA0KIENvbXBvbmVudDogIHNxbCAgICAgICB8ICAgICBWZXJzaW9uOiAgICAgICAgDQpSZXNv
bHV0aW9uOiAgZml4ZWQgICAgIHwgICAgS2V5d29yZHM6ICAgICAgICANCi0tLS0tLS0tLS0tLS0t
LS0tLS0tLS0tKy0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t
LS0tLS0NCkNoYW5nZXMgKGJ5IHp6emVlayk6DQoNCiAgKiByZXNvbHV0aW9uOiAgPT4gZml4ZWQN
CiAgKiBzdGF0dXM6ICBuZXcgPT4gY2xvc2VkDQoNCkNvbW1lbnQ6DQoNCiBJIHB1dCBhIHByZXR0
eSBzaW1wbGUgcnVsZSBpbiB0aGF0IGhvcGVmdWxseSBjb3ZlcnMgYWxsIHRoZSBiYXNlcyAoZG9l
c250DQogY292ZXIgYm9vbGVhbnMgbGlrZSBBTkQgYW5kIE9SIGJ1dCB0aG9zZSB1c2UgYSBzbGln
aHRseSBkaWZmZXJlbnQgcnVsZSksDQogd2hpY2ggaXMganVzdDogIGJpbmFyeSBjbGF1c2UsIGlm
IGxlZnQgaXMgYWxzbyBhIGJpbmFyeSB0aGVuIHBhcmVudGhlc2l6ZQ0KIGl0LCBpZiByaWdodCBp
cyBhbHNvIGEgYmluYXJ5IHRoZW4gcGFyZW50aGVzaXplIGl0Lg0KDQogdGhpcyBoYXMgdGhlIGVm
ZmVjdCBvZiB0aGUgbmF0dXJhbCBweXRob24gb3JkZXIgb2Ygb3BlcmF0b3JzIG1hbmlmZXN0aW5n
DQogaXRzZWxmIGFzIHBhcmVudGhlc2lzIHRvIG1ha2UgdGhlIG9yZGVyIGV4cGxpY2l0IGluIGFs
bCBjYXNlcy4gIGkgd291bGQgYmUNCiBhIGxpdHRsZSBjb25jZXJuZWQgYWJvdXQgZXhjZXNzIHBh
cmVudGhlc2lzIGJ1dCBpdCBzZWVtcyB0byBob2xkIHVwIHByZXR0eQ0KIHdlbGwgc28gZmFyLCBp
dHMgaW4gW2NoYW5nZXNldDoxMjM2XS4NCg0KLS0gDQpUaWNrZXQgVVJMOiA8aHR0cDovL3d3dy5z
cWxhbGNoZW15Lm9yZy90cmFjL3RpY2tldC8xNDQ+DQpzcWxhbGNoZW15IDxodHRwOi8vZXhhbXBs
ZS5jb20vPg0KTXkgZXhhbXBsZSBwcm9qZWN0