How to log SQL queries executed during migrations in ASP.NET Core and send them via email?

[s-shodiev]

I need to implement a solution in ASP.NET Core (using Entity Framework Core) to log SQL queries executed during migrations (e.g., CREATE TABLE, ALTER TABLE, DROP) and send them via email in the following format:

Migration: migration filename
SQL query: SQL query

The solution should only track SQL queries related to migrations, not runtime queries from DbContext. How can I achieve this?