I have 14+ years experience in developing Excel - VBA applications, macros, custom functions and complicated formulas.
I use pure SQL queries to interact with Excel front-end, reports and database. No matter what type of database are you using e.g. Excel, Access, Sql Server, MySql or any other database. I know to handle the database and make the application lighter.