A cute way to build dynamic sql by interpolating a string (#interpolation)

dynamic-interpolated-sql-string.sql

DECLARE @message VARCHAR(MAX) = 'Some {item} with {count} {collection}.';

-- Via https://stackoverflow.com/a/77054331/370611
-- Recursive expression, frowned upon by https://learn.microsoft.com/en-us/sql/t-sql/language-elements/select-local-variable-transact-sql?view=sql-server-ver16#c-antipattern-use-of-recursive-variable-assignment
-- But... it does seem to work.
SELECT @message = REPLACE(@message, SearchText, ReplaceText)
FROM ( VALUES                       -- Table constructor (literal), anonymous table, essentially.
  ('{item}', 'text string'),
  ('{count}', '3'),
  ('{collection}', 'variables')
) _ (SearchText, ReplaceText);      -- "_" is essentially an anonymous table alias, not used elsewhere. The tuple is column names.

select @message;