stephencelis/SQLite.swift ? reverse-engineered prompt
Reverse engineered prompt
Build me a Swift library that makes working with SQLite feel safe and easy. I want a clean, Swift friendly layer over SQLite3 that lets me define tables, columns, inserts, updates, deletes, and selects without writing raw SQL everywhere, while still letting me use raw SQL when I need to. It should handle optional values properly, give good error messages, and make common things like counting rows, filtering, and reading typed values from query results feel simple.
Please include solid documentation and a few example snippets showing how to create a database, make a users table, insert rows, query them back, update a value, and delete a row. Add tests too, so the main query and schema features are covered. If there are platform specific details or current SQLite docs I should know about, look them up online if needed.
Are you gonna build this?
make sure you review the code using coderabbit