autoimport does not correctly use index

[lieryan]

Describe the bug

Related conversation:

• https://github.com/python-rope/rope/pull/730/files#r1385746802

@MrBago made an IPython notebook testing the performance of an unrelated query. This brings up an unrelated performance issue with the search_by_module_like and likely the other like queries as well.

A prefix search using an index should not have been that slow. Indeed, it doesn't seem to be correctly using the index as EXPLAIN QUERY PLAN shows that it is doing a full table scan on the LIKE query so the index doesn't seem to be defined correctly, I think this is because of a case sensitivity issue on the index.

To Reproduce
Steps to reproduce the behavior:

In [78]: %time _ = list(autoimport._execute(m.Name.search_module_like.select_star(), ["abc"]))

[tkrabel-db]

@lieryan are there any updates on this issue? Do you have an ETA when you want to do this? I have capacity to work on this, so I am happy to help!