You can massage this data in lots of ways.

That's a good question — but sometimes, despite a good API choice, you will have to massage the data some.

Wilson provides enough SQL to help you learn how to massage data in a relational database, and he also covers tables, joins, negation, and nested queries.