Add arbitrary claims from SQL Server after AzureAD login

I couldn’t find a good title for this blogpost, so let me expand it further. Sometimes after login, you need to run custom processing logic. For instance,

1. Maybe you want to tap into a SQL server data source to add any arbitrary claims for the logged in user. Azure AD lets you add claims, but maybe you need more flexibility, such as running some logic, and adding claims based on that (instead of a flat value).
2. Or maybe, you want to show some custom UI to prompt the user to add more information, perhaps combine…