SQLite Forum

.expert via api
Login
Is it already (or will it in the future be) possible to do the equivalent of the cli .expert command via api?

My use case is that I have a complex program that uses the SQLite c-api and which generates 1000s of queries dynamically. I would like to extend the debugging/development mode of the program to use  equivalent .expert functionality so that I can log potential indices that I should add in order to improve query performance. I would then manually analyse the logs and determine which (if any) indices that I will create and then add these to the list if indices that the program creates.