What it is
SQL data masking replaces sensitive column values with partial reveals, redactions, or hashes directly in the database, either destructively via UPDATE or non-destructively via a masked view.
When to use it
Database and privacy engineers use this when preparing a production data copy for a lower environment, or exposing a masked view to users who should not see raw sensitive columns.
Gotchas & limits
Generated SQL is dialect-specific; a statement written for PostgreSQL's masking functions will not run unmodified against MySQL or SQL Server, so pick the right dialect before running it.