Use composition, views are great for that, modern databases will optimize trough views as well so it's not like the day of old where a view with a join was an a

Use composition, views are great for that, modern databases will optimize trough views as well so it's not like the day of old where a view with a join was an all consuming monster. We already had the best minds in the world to try and replace sql, but because sql is rooted in group theory and math is hard to budge they all eventually had to get back and implement the group bys and havings and whatnot that complicate the sql syntax, except tackled on and with their proprietary syntax.