Common use cases for the hex() function include: * Convert a binary blob into human-readable format. * Generate a unique identifier or random password using an expression like: "`hex(randomblob(20))`" * Generate human-readable hash strings from extension functions like [sha3()](https://www.sqlite.org/src/file/ext/misc/shathree.c) that otherwise return a binary blob. Ex: "`hex(sha3(...))`" * To view the actual UTF8 (or UTF16) of a text string.