New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Document Template SQL file support #7

Open

kdhrubo opened this issue Jan 19, 2024 · 1 comment

Assignees

Labels

Milestone

Collaborator

kdhrubo commented Jan 19, 2024 •

edited by thadguidry

Loading

So what it does is you can write SQL with conditions and named parameters and store those with DB2REST. Then DB2REST will call those based on URL request and return results

Collaborator

thadguidry commented Jan 21, 2024

Make sure we something to the effect of this:

99% of the time your subqueries likely NEED and should be rewritten as JOINs. But in DB2Rest, if you REALLY need to do a subquery (i.e. not rely on the columns in the outer query) then you will need to use a CUSTOM SQL EXPRESSION

thadguidry mentioned this issue

Template SQL file support 9tigerio/db2rest#670

Closed

4 tasks

kdhrubo changed the title ~~Document custom query~~ Document Template SQL file support

kdhrubo self-assigned this

kdhrubo added the documentation label

kdhrubo added this to the Nov2024 milestone

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment