While SQL does not seem overly glamorous. It is a very clear and easy method to do database queries. Having done his with pandas off and on. I find that SQL is much easier, and clearer, once you learn the syntax, and understand what the results will be. I created a basic ERD (entity relationship diagram) as well as creating the tables, and performing queries and joins on the data contained within.