SQL Auto-Completion Enhancement for tables and columns

loalexzzzz's profile image loalexzzzz posted 2 years ago in Feature discussion Permalink

I like HeidiSQL so much, but I have one suggestion on SQL auto-completion.

Tables

BA_AUDIT_LOG, BA_APP_LOOKUP

Existing

BA_AUDIT_LOG = type "AUDIT_LOG", pop up "BA_AUDIT_LOG" BA_AUDIT_LOG = type "AL", pop up nothing

Expected

BA_AUDIT_LOG = type "AUDIT_LOG", pop up "BA_AUDIT_LOG" BA_AUDIT_LOG = type "A_L", pop up "BA_AUDIT_LOG" or "BA_APP_LOOKUP" BA_AUDIT_LOG = type "AU_L", pop up "BA_AUDIT_LOG"

Could it be enhanced in that way? In a similar way to JetBrain's DataGrip, typing such a word would be faster and easier.

Thank you for creating such an amazing tool. I love it so much!

loalexzzzz's profile image loalexzzzz posted 2 years ago Permalink

Sorry for reposting due to bad formatting.

I like HeidiSQL so much, but I have one suggestion on SQL auto-completion.

Tables

  • BA_AUDIT_LOG, BA_APP_LOOKUP

Existing

  • type "AUDIT_LOG", pop up "BA_AUDIT_LOG"
  • type "AL" or "A_L", pop up nothing

Expected

  • type "AUDIT_LOG", pop up "BA_AUDIT_LOG"
  • type "A_L" or "AL", pop up "BA_AUDIT_LOG" or "BA_APP_LOOKUP"
  • type "AU_L", pop up "BA_AUDIT_LOG"

Could it be enhanced in that way? In a similar way to JetBrain's DataGrip, typing such a word would be faster and easier.

Thank you for creating such an amazing tool. I love it so much!

ansgar's profile image ansgar posted 2 years ago Permalink

You can activate "matches in the middle" for auto completion proposal:

Description

Please login to leave a reply, or register at first.