Ensuring %%sql magic pushes LIMIT/OFFSET to the database server for efficient pagination
The goal is to rely on the %%sql magic from ipython-sql to apply LIMIT and OFFSET directly in the database query, thereby avoiding the transfer of large result sets to the notebook kernel. However, the documentation does not guarantee server‑side push‑down for all adapters; SQLite may fetch the full set and filter in Python, and behavior can shift with ipyth