Ask HN: An Issue Tracker for Hackers

I've used Jira and "CA Agile Central" / "Rally" for tracking issues in the past. I use OmniFocus personally. One of my major gripes with all of these is that they don't make it easy to access your data. For both my team and my personal tasks I want a bug tracker that:

* Has a SQL based query interface.

* Is scriptable with Python or Javascript.

* Has an API that that allows me to CRUD tasks for integration with other tools.

I know that a lot of things are out there but the experience for a power user kind of sucks. Jira is shockingly slow and JQL is not fun to use. OmniFocus is not scalable for me and my partner. Which tool is simple, fast, and exposes the data in a way that makes it easy to manipulate?