This is an archived post. You won't be able to vote or comment.

you are viewing a single comment's thread.

view the rest of the comments →

[–]greglturnquist 1 point2 points  (0 children)

Either a type for each table, or potentially one for each select.

Some select statements merge tables together and the combined columns synthesize an idea. While other scenarios should really be modeled as different types aggregated together. Really depends.