Comment by pinars

As a quick side note, PostgreSQL had the HyperLogLog data type for a while: https://github.com/aggregateknowledge/postgresql-hll

For people who need SQL and HyperLogLog, we found this extension to work pretty well.