Full text search against logged responses

[simonw]

Could be a really useful feature. Since we have prompt and response text columns, why not enable FTS on them?

Then we can support llm logs -q 'search term'. And have search in the web UI too.

[simonw]

I was torn between the following options for searching for logs matching a term:

• llm logs -q/--query
• llm logs -s/--search

I chose -q/--query - the -s one could be confused with -s/--system used by the llm prompt command.

I was worried that -q/--query might indicate that this takes a custom SQL query, but I figure I can use --sql or --where for that if I ever implement that feature.