docstr: Mapper load strategy defaults can be upgraded with
  subqueryload('*') option, while multiple explicit
  joinedload() options are still honored
docstr_tok: ["Mapper","load","strategy","defaults","can","be","upgraded","with","subqueryload","(","'","*","'",")","option",",","while","multiple","explicit","joinedload","(",")","options","are","still","honored"]
code: def test_subquery_with_joinedload(self):
      """Mapper load strategy defaults can be upgraded with
      subqueryload('*') option, while multiple explicit
      joinedload() options are still honored"""
      sess = self._upgrade_fixture()
      users = []
  
      # test upgrade all but 'addresses' & 'orders', which are joinedloaded
      # (1 sql + items + keywords = 3)
      def go():
          users[:] = (
              sess.query(self.classes.User)
              .options(joinedload(self.classes.User.addresses))
              .options(joinedload(self.classes.User.orders))
              .options(subqueryload("*"))
              .order_by(self.classes.User.id)
              .all()
          )
  
      self.assert_sql_count(testing.db, go, 3)
  
      # verify everything loaded, with no additional sql needed
      self._assert_fully_loaded(users)
  
imports: import sqlalchemy
  from sqlalchemy import testing
  from sqlalchemy import util
  from sqlalchemy.orm import defaultload
  from sqlalchemy.orm import joinedload
  from sqlalchemy.orm import relationship
  from sqlalchemy.orm import subqueryload
  from sqlalchemy.testing import eq_
  from sqlalchemy.testing.assertions import expect_raises_message
  from sqlalchemy.testing.fixtures import fixture_session
  from test.orm import _fixtures
label_desc: Use image node_id 23 for calling the DefaultStrategyOptionsTest obj's underlying member method code with example usage: obj.test_subquery_with_joinedload() without return types