> Can Record objects be queried after the database connection is closed?
Yes. Unlike the JDBC ResultSet (which represents a cursor on the database), all data is fetched into Result (and its contained Records) at query execution time. So a Record's values are still available after the connection is closed.
