To remove just libghc-hdbc-sqlite3-prof package itself from Debian 9 (Stretch) execute on terminal:
sudo apt-get remove libghc-hdbc-sqlite3-prof
Uninstall libghc-hdbc-sqlite3-prof and it's dependent packages
To remove the libghc-hdbc-sqlite3-prof package and any other dependant package which are no longer needed from Debian Stretch.
sudo apt-get remove --auto-remove libghc-hdbc-sqlite3-prof
If you also want to delete configuration and/or data files of libghc-hdbc-sqlite3-prof from Debian Stretch then this will work:
sudo apt-get purge libghc-hdbc-sqlite3-prof
To delete configuration and/or data files of libghc-hdbc-sqlite3-prof and it's dependencies from Debian Stretch then execute:
sudo apt-get purge --auto-remove libghc-hdbc-sqlite3-prof
More information about apt-get remove
apt-get remove is identical to install except that packages are removed instead of installed. Note that removing a package leaves its configuration files on the system. If a plus sign is appended to the package name (with no intervening space), the identified package will be installed instead of removed.