Support for "WITH (DATA_COMPRESSION = COLUMNSTORE | COLUMNSTORE_ARCHIVE)" for inline index

[zacateras]

• SqlPackage or DacFx Version: latest
• .NET Framework (Windows-only) or .NET Core: .NET 8
• Environment (local platform and source/target platforms): net8.0-windows x64

Steps to Reproduce:

using Microsoft.SqlServer.TransactSql.ScriptDom;

var script = @"
  CREATE TABLE [dbo].[Sample](
  [ID] [int] NULL,
  [Code] [varchar](100) NULL,
  INDEX [IDX] CLUSTERED COLUMNSTORE WITH (DATA_COMPRESSION = COLUMNSTORE)
)
";

var parser = new TSql150Parser(false);
var fragment = parser.Parse(new StringReader(script), out var parseErrors);

Console.WriteLine(parseErrors[0].Message);

// Outputs:
// "Option 'DATA_COMPRESSION' is not a valid index option in 'CREATE TABLE (inline index)' statement."