@kapa.ai Objective:
I need to perform a query on WordPress data stored in a MySQL database using LlamaIndex.

Query Details:

Target Table and Column: Search within the post_content column of the wp_posts table.
Join Requirement: Join wp_posts with wp_post_meta on wp_posts.ID equals wp_post_meta.post_id.
Filtering Criteria:
Filter posts based on the valid_from and valid_to fields in the wp_post_meta table.
If a specific date is provided in the query, select posts where this date falls between valid_from and valid_to.
If no date is provided, select posts where valid_to is empty or null.

Questions:

Should I directly use a database reader for querying, or should I convert the entire database content into vectors and store them in a vector database like Chroma, and then perform queries via VectorIndex?
What should be the order of operations in the query process—should I apply the filter before querying the content, combine both in a single SQL-like query, or filter the results after querying?
Are there other considerations I should keep in mind, such as performance impacts, indexing strategies, or specific configurations in LlamaIndex for handling SQL data?