code: def test_iter_sql_join(pokedb):
      query = """
          SELECT
              p.name,
              t1.name AS type_1,
              t2.name AS type_2
          FROM
              pokemons p,
              pokemon_types pt1,
              pokemon_types pt2,
              types t1,
              types t2
          WHERE
              pt1.no = 1 AND
              pt1.pokemon_id = p.id AND
              pt1.type_id = t1.id AND
  
              pt2.no = 2 AND
              pt2.pokemon_id = p.id AND
              pt2.type_id = t2.id;
      """
  
      with pokedb.connect() as conn:
          dataset = stream.iter_sql(query=query, conn=conn)
          x, y = next(dataset)
          assert x["name"] == "Bulbasaur"
          assert x["type_1"] == "Grass"
          assert x["type_2"] == "Poison"
  
file_path: river/river/stream/test_sql.py
imports: from __future__ import annotations
  import json
  import os
  import zipfile
  import pytest
  import sqlalchemy
  from river import stream
label_desc: Use image node_id 3 for calling a global function with example usage: test_iter_sql_join(pokedb) without return types