Re: [sqlalchemy] best way to handle custom compiler that proxies to different known functions

2016-06-30 Thread Mike Bayer
On 06/30/2016 05:59 PM, Jonathan Vanasco wrote: postgresql allows for comparing result columns via `LEAST` sqlite allows for comparing result columns via `min` so the correct query is... postgresql - ... order by least(col_a, col_b) sqlite - ... order by min(col_a, col_b) I tossed

[sqlalchemy] best way to handle custom compiler that proxies to different known functions

2016-06-30 Thread Jonathan Vanasco
postgresql allows for comparing result columns via `LEAST` sqlite allows for comparing result columns via `min` so the correct query is... postgresql - ... order by least(col_a, col_b) sqlite - ... order by min(col_a, col_b) I tossed together a custom compiler that works for my