SQL queries files management

[jparis-arpege]

I would like to be able to manage my sql queries files from commands and UIs actions.

• I'd like to be able to link files to a database, table, etc. These files are saved either locally or user-scoped (so I can find them from another computer using the user account)
  • Commands :
    • "Open/create linked file" -> Choose connection profile -> Choose database -> List of linked files and "create new" option.
    • "Delete linked file" -> Choose connection profile -> Choose database -> Choose linked file -> confirmation.
    • "See linked files in file explorer" -> Opens file explorer where script files are located.
    • "Open default file". Allow me to mark a single file per database/table/db element as "default". The command asks the user to select connection profile and database. If the file doesn't exists, creates it.
  • Right click on a database/table/db element shows these commands without having to choose the connection profile and db element.
  • When opening a linked file, it shows the connection, database[,table/db element, ...] and file within the breadcrumbs.
    • The breadcrumbs allows to switch file, database and connection profile.