PostgreSQL Exercises
This seems as good of place as any to ask novice-level questions about PostgreSQL. I teach students SQLite and one of the most massive pain points in transitioning to PgSQL is how the latter, in the `WHERE` clause, fails to recognize aliases in the `SELECT` clause, e.g.<p><pre><code>   SELECT UPPER(name) AS bigname
   FROM people
   WHERE bigname = 'JOE';
</code></pre>
<a href="https://stackoverflow.com/questions/38040631/postgresql-does-not-accept-column-alias-in-where-clause" rel="nofollow">https://stackoverflow.com/questions/38040631/postgresql-does...</a><p>Apparently this is the SQL standard, which PgSQL seems to do a better job of following than SQLite, but I'm at a loss to understand why this computation is particularly problematic for PgSQL (or any variant) to adopt? Unlike other SQL standard rules that PgSQL follows that SQLite/MySQL doesn't (such as forbidding the selection of column names that aren't being GROUPed by in a GROUP BY clause), this strictness seems to be all inconvenience.