Star names and the HYG Database
What about BSC5p for stars brighter than magnitude 6.5? The "alt_name" "is usually the Flamsteed and/or Bayer constellation-based name for the star".

Here a list of more advanced catalogs.

Here a list of some common star names for Hipparcos numbers. Probably not much different from your query result.

On Wikipedia a probably more complete list of more or less wide-spread common star names.

Those common names often are not unique, and not all common names are widely accepted. That's probably why they aren't provided in the star catalogs.

The only way I could imagine to get a solution is to convert the Wikipedia table to a csv file, and to import it to a database table used as a relation from the various catalog names to the proper names. That will probably need quite a bit of manual work.

None of the naming systems is complete, not even necessarily unique. Stars frequently turn out to be not one, but several stars, or no star at all. At some point it's easier to use 'scientifics'.