Call an API from Every Row in DuckDB, Without the Loop

DuckDB's LATERAL join enables calling APIs for each row in a table without explicit loops, using table functions that return zero or more rows per input. The Vector Gateway Interface (VGI) optimizes these remote API calls by exchanging data as Apache Arrow, allowing functions written in any language to run in separate processes.