Scalar Functions — Hash / Crypto

Hash functions compute digests over string values. MySQL, ClickHouse, and PostgreSQL all support MD5, SHA-1, and SHA-256 natively. SQLite has no built-in hash functions and will emit a warning and fail for any of these calls.

Legend: ✅ Supported · ⚠️ Approximated · ❌ Not Supported · 🔄 Rewritten

Function	SQLite	MySQL	ClickHouse	PostgreSQL	Notes
hash_md5()	⚠️	✅	✅	✅	SQLite: unsupported with warning
hash_sha256()	⚠️	✅	✅	✅	MySQL: SHA2(col, 256); SQLite: unsupported with warning
hash_sha1()	⚠️	✅	✅	✅	MySQL: SHA1(); Postgres: encode(digest(...,'sha1'),'hex'); SQLite: unsupported with warning
hash()	✅	✅	✅	✅	Passed through as-is

warning

SQLite does not include any cryptographic functions. Using hash_md5(), hash_sha1(), or hash_sha256() against a SQLite target will emit a runtime warning. If hashing is required, consider switching to a ClickHouse or PostgreSQL target for those pipeline stages.