How to query a SQL database from Pandas

This post details how to query SQL databases directly into Pandas DataFrames using Python. It covers establishing connections via SQLAlchemy and SQLite, and demonstrates using `pandas.read_sql` with various SQL queries, including filtering, limiting, and dynamic query construction. It also highlights the `chunksize` argument for handling large datasets and shows an example of plotting data directly from a SQL query.