Index patterns for Querying nested collection

Plugins SQL
6

I see.
I did a test to confirm that wildcard in index name works there. The main obstacle in your query is a self join defined by

employees_nested* AS e,
       e.projects AS p

Can you try this query?

SELECT e.name AS employeeName,
       e.projects.name AS projectName
FROM employees_nested* AS e
WHERE e.projects.name LIKE '%security%'