organize large sql queries into sqlite db, in place of lots of Excel pivots and vlookups

I'm trying to automate a project that in the past had been done in Excel - the process involves exporting 7-8 large SQL queries into Excel files, cleaning the data, doing vlookups with mapping tables, and pivot tables. I'm thinking about the best way to automate the process using python and maybe SQLite.

Is it possible to export large sql queries and mapping tables into SQLite, clean the data in Python, and doing queries on SQLite rather than pivot tables?