WITH
    XMLNAMESPACES (DEFAULT 'http://schemas.microsoft.com/sqlserver/2004/07/showplan')
SELECT
    qsqt.query_sql_text,
    query_plan = TRY_CAST(qsp.query_plan AS xml),
    query_statistics_compiled_parameters =
        TRY_CAST(qsp.query_plan AS xml).query('//ParameterList/ColumnReference')
FROM sys.query_store_plan AS qsp
JOIN sys.query_store_query AS qsq
  ON qsp.query_id = qsq.query_id
JOIN sys.query_store_query_text AS qsqt
  ON qsq.query_text_id = qsqt.query_text_id
WHERE qsq.query_parameterization_type_desc = N'User';

WITH
    XMLNAMESPACES (DEFAULT 'http://schemas.microsoft.com/sqlserver/2004/07/showplan'),
    p AS
(
    SELECT
        qsqt.query_sql_text,
        query_plan = TRY_CAST(qsp.query_plan AS xml)
    FROM sys.query_store_plan AS qsp
    JOIN sys.query_store_query AS qsq
      ON qsp.query_id = qsq.query_id
    JOIN sys.query_store_query_text AS qsqt
      ON qsq.query_text_id = qsqt.query_text_id
    WHERE qsq.query_parameterization_type_desc = N'User'
)
SELECT
    p.*,
    parameter = qp.p.value('@Column', 'sysname'),

DECLARE @result int;
EXEC @result = sp_getapplock @Resource = '__EFMigrationsLock', @LockOwner = 'Session', @LockMode = 'Exclusive';
SELECT @result

IF OBJECT_ID(N'[__EFMigrationsHistory]') IS NULL
BEGIN
    CREATE TABLE [__EFMigrationsHistory] (
        [MigrationId] nvarchar(150) NOT NULL,
        [ProductVersion] nvarchar(32) NOT NULL,
        CONSTRAINT [PK___EFMigrationsHistory] PRIMARY KEY ([MigrationId])
    );
END;

SELECT [MigrationId], [ProductVersion]
FROM [__EFMigrationsHistory]
ORDER BY [MigrationId];