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

ADR: key decisions in constructing sql queries #32

Closed

machow opened this issue May 12, 2019 · 1 comment

Owner

machow commented May 12, 2019

References

Variable defined in select can't be referenced in where clause. SO Post
Variable defined in select can't be referenced by subsequent column defs

Strategies to document

arrange modifies order by clause, so does not need to create new query if referencing a just defined column
filter modifies where clause, so does need to create new query if...
- referencing just created column
- using window / aggregate expressions

Owner Author

machow commented May 19, 2019

whoops, duplicate of #24, copied contents from here to there

machow closed this as completed

machow added this to siuba

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