Unless statements are executed in the session are not fully qualified it fail if no current database, schema ever set.
Support USE DATABASE, USE SCHEMA statements.
Support setting database, schema specified in connection settings, for instance in snow sql.