alchemy-utils 0.1a0

This article announces the alpha release of alchemy-utils 0.1a0, a Python library and CLI utility that provides a database-agnostic version of sqlite-utils, built on SQLAlchemy. It supports multiple database engines including PostgreSQL, SQLite, and DuckDB. The author describes using AI tools to prototype the project, which includes methods like insert, upsert, insert_all, upsert_all, create, and update, as well as table introspection. Examples show usage with PostgreSQL and DuckDB, including a one-liner to list rows from a PostgreSQL database and a command to insert CSV data into DuckDB. The article is relevant to IT/technology as it covers software development, database tools, and Python libraries.