Thank you for the response.
Will it still be possible for me to perform dynamic searches. Such as user can select a car make ,model, year, and then category. Then perform SQL query to pull the required products from the database and load them into the WooCommerce product page ?