code: def test_join_lateral_w_select_subquery(self):
      table1 = self.tables.people
      table2 = self.tables.books
  
      subq = (
          select(table2.c.book_id)
          .correlate(table1)
          .where(table1.c.people_id == table2.c.book_owner_id)
          .subquery()
          .lateral()
      )
      stmt = select(table1, subq.c.book_id).select_from(
          table1.join(subq, true())
      )
  
      self.assert_compile(
          stmt,
          "SELECT people.people_id, people.age, people.name, anon_1.book_id "
          "FROM people JOIN LATERAL (SELECT books.book_id AS book_id "
          "FROM books "
          "WHERE people.people_id = books.book_owner_id) AS anon_1 ON true",
      )
  
imports: from sqlalchemy import Column
  from sqlalchemy import column
  from sqlalchemy import ForeignKey
  from sqlalchemy import Integer
  from sqlalchemy import join
  from sqlalchemy import lateral
  from sqlalchemy import String
  from sqlalchemy import Table
  from sqlalchemy import table
  from sqlalchemy import testing
  from sqlalchemy import text
  from sqlalchemy import true
  from sqlalchemy.engine import default
  from sqlalchemy.sql import func
  from sqlalchemy.sql import select
  from sqlalchemy.sql.selectable import Lateral
  from sqlalchemy.testing import assert_raises_message
  from sqlalchemy.testing import AssertsCompiledSQL
  from sqlalchemy.testing import fixtures
label_desc: Use image node_id 10 for calling the LateralTest obj's underlying member method code with example usage: obj.test_join_lateral_w_select_subquery() without return types