DB-connection schema compatibility for the Query Builder

[marknuyens]

Hello everyone,

It appears that when you're using multiple (PostgreSQL) connections and define their respective schema (e.g. "public"), this schema name is not taken into account when using the Query Builder, even when the model uses the correct connection.

Only when explicitly setting the schema name before the table name using the $table property on the model, this appears to be working. However, I would argue that this could be automated by always checking for the schema name inside the database connection configuration.

Would do you guys think of this behavior; should this be automated or am I simply too lazy? ;-)
Anyway, would love to hear your opinion!