New here (with a question) - SQL Client for CSV files (w/Joins)?

[tomypayne64]

Hello all! I am a Full-Stack Developer (mainly with Ruby on Rails/C#/SqlServer & Postgres. Anyways, for a long time I have been plagued with the problem of dealing with Excel and CSV files and their interaction (or lack therof) with databases. I have looked far and wide for a software that would allow me to treat CSV files like a database tables. I know that DBeaver can open CSV files and allow you to do queries on a SINGLE file, but I am looking for some kind of software that allows one to JOIN csv files to each other and possibly to other schemas. Is there such a software out there? For now I am relegated to exporting a table to csv from a database, them importing that to a custom schema, then importing a csv file to the same schema, then finally I can JOIN the two and execute the needed queries. Anyways, thanks for reading this!