Clean up and improve get studies sql statements

datakind / permanent-colandr-back

DataCorps - Colandr Tool resources

https://www.colandrapp.com/signin

14 stars 1 forks source link

Closed bdewilde closed 4 months ago

bdewilde commented 4 months ago

port big chunks of textual sql logic into sqlalchemy orm equivalents, and with faster logic too
tidies up other bits of sql weirdness in the get studies api endpoint
adds a test case for a missing code branch