I use a one-file-per-day system in VS Code and I do that by doing global search with file filtering. So I might search for FROM table_name and only match

I use a one-file-per-day system in VS Code and I do that by doing global search with file filtering. So I might search for FROM table_name and only match in files like dailies/2022-09-*