I was about to just recommend you pandas, but just realized it doesn't natively support running sql on dataframes, but pyspark does!