docstr: test #9772
docstr_tok: ["test","#","9772"]
code: def test_values_in_scalar_subq(self):
      """test #9772"""
  
      people = self.tables.people
      table_value_constructor = Values(
          Column("v1", Integer), name="tvc"
      ).data(
          [
              (people.c.people_id,),
              (people.c.age,),
              (people.c.name,),
          ]
      )
  
      maximum = select(func.max(table_value_constructor.c.v1))
      maximum_subquery = maximum.scalar_subquery()
      query = select(people.c.people_id, maximum_subquery)
      self.assert_compile(
          query,
          "SELECT people.people_id, "
          "(SELECT max(tvc.v1) AS max_1 FROM "
          "(VALUES (people.people_id), (people.age), (people.name)) "
          "AS tvc (v1)) AS anon_1 FROM people",
      )
  
imports: from sqlalchemy import alias
  from sqlalchemy import Column
  from sqlalchemy import column
  from sqlalchemy import Enum
  from sqlalchemy import exc
  from sqlalchemy import ForeignKey
  from sqlalchemy import Integer
  from sqlalchemy import String
  from sqlalchemy import Table
  from sqlalchemy import table
  from sqlalchemy import testing
  from sqlalchemy import true
  from sqlalchemy import values
  from sqlalchemy.engine import default
  from sqlalchemy.sql import func
  from sqlalchemy.sql import select
  from sqlalchemy.sql import Values
  from sqlalchemy.sql.compiler import FROM_LINTING
  from sqlalchemy.testing import AssertsCompiledSQL
  from sqlalchemy.testing import expect_raises_message
  from sqlalchemy.testing import fixtures
  from sqlalchemy.testing import is_
  from sqlalchemy.testing import is_not
  from sqlalchemy.util import OrderedDict
label_desc: Use image node_id 9 for calling the ValuesTest obj's underlying member method code with example usage: obj.test_values_in_scalar_subq() without return types