What inspired this wish list request?
As the problem asked in Re: How to automatically detect primary key and secondary key of SQLite when ope... - JMP User Commu..., currently JMP can only auto detect primary-keys/foreign-keys/indexed columns by using an ODBC driver, while opening a SQLite file directly cannot.
What is the improvement you would like to see?
JMP is able to detect SQLite primary-keys/foreign-keys/indexed columns without an ODBC driver.
Why is this idea important?
It would make SQLite data access a lot simpler by getting rid of adjusting table joining conditions manually.