Build a single LATERAL JOIN SQL clause.

Build LATERAL JOIN SQL clauses from specifications.

Takes a list of LATERAL join specifications and generates the corresponding SQL JOIN clauses with LATERAL keyword and proper correlation handling.

Examples

iex> build_lateral_joins([lateral_spec])
{["LEFT JOIN LATERAL (SELECT ...) AS recent_rentals ON true"], [param1, param2]}

Integrate LATERAL joins into the main SQL generation pipeline.

This function is called by the main SQL builder to include LATERAL JOIN clauses in the generated SQL.