hankinsoft
Feature Request: Show intellisense for more "order by" columns than the first column
Is your feature request related to a problem? Please describe. When I type "select * from x order by ", the intellisense shows various column names that I can press tab to select. If I then type ", " to try to order by a second column, the intellisense doesn't show any column names. In the current query that I'm working with, intellisense instead shows
ASC (keyword) DESC (keyword) then the names of all of my favorite queries, one per line
Describe the solution you'd like I wish the intellisense worked on columns after the first column.
Describe alternatives you've considered Type column names from memory or switch to the Schema tab to look up the column name.
Additional context If this is very difficult to implement, this request can be closed.
Environment (please complete the following information):
- Device: iMac
- OS: macOS Ventura 13.7.2
- SQLPro app Version: SQLPro for SQLite Version 2024.30 (Build 4374)
2025.06 is now available via the App Store, website and setapp app. This build should sort this issue to out. If you get the chance, please give it a try and let me know if this is resolved.
My last comment is showing that the problem exists with the first intellisense launch in a regular SET command. This issue was originally addressing the problem in the intellisense launch for the second ORDER BY command.
Would a preference 'Show favourites in autocomplete' that you could un-toggle sort this?
I don't think there will ever be a situation where I want to launch a query from a set or order by command. So a preference setting wouldn't help.
Resolved in https://sqlprostudio.s3.us-east-1.amazonaws.com/sqlite/SQLProSQLite.2025.25.app.zip.
I downloaded 2025.25 but it doesn't launch on my computer. I noticed that 2025.25 doesn't show as an update in 2025.07's interface so maybe I wasn't supposed to run 2025.25 yet. On the other hand, you provided a link to the zip file instead of just saying that it will be downloadable later in an official release.
I noticed that 2025.25 doesn't show as an update in 2025.07's interface so maybe I wasn't supposed to run 2025.25 yet. On the other hand, you provided a link to the zip file instead of just saying that it will be downloadable later in an official release.
The new build is not available as an official release yet do to the import changes. I'm passing them to a few users first to confirm all changes work properly before pushing it to the official release.
I downloaded 2025.25 but it doesn't launch on my computer.
Hmmm, thats odd. No 'SQLPro failed to launch' or any such errors either?
I deleted the log file, tried a launch of 2025.25, saw that it didn't launch, launched 2025.07, saved the log as the attached file.
com.hankinsoft.osx.sqliteprofessional 2025-06-23--06-55-21-725.log
If you get the chance, could you please try: https://sqlprostudio.s3.us-east-1.amazonaws.com/sqlite/SQLProSQLite.2025.27.app.zip