• I understand your overall point.

    behave as if you were a lower version when running queries in this DB

    I would argue that SQL Server is not doing this since the query syntax is different in the lower version than the newer version. It is fact not behaving like it was a lower version when running this query in the database.