Ingesting JSON data dynamically to a SQL Server database with ADF/Synapse

Quick introduction to Integration Pipeline in Azure Data Factory / Synapse Analytics
How do we go from semi-structured JSON data to a relational SQL table?
Demo: Dynamic data mapping with a metadata driven copy activity