1. Since PostgreSQL is built on top of SQL - I’m assuming that all querying can be done using SQL statements in addition to some of the stuff Postgres adds to seed/traverse the database via the terminal? Are there any weird things that Postgres adds to SQL?
PSQL is not built on top of SQL. PSQL uses its own flavor of SQL language to communicate with a database. PSQL is a DBMS and SQL is a querying language.
They work together to accomplish the goal of communicating with a database. PSQL has its own features that make it unique as a DBMS such as JSON storage support (No-SQL style). I would not say there is anything “weird” in PSQL, other than extra features that you might find handy.
2. Is it ever best practice (or even possible) to store actual JavaScript code into a table? If so, what are the use cases for that?
It is relativity easy to store code in a database. Code of any language always breaks down simply into a long string that you could hypothetically store in a field. It is highly recom