FluentMigrator support?

[jzabroski]

Hi @phillipleblanc , I am the maintainer of FluentMigrator, a popular C# framework that abstracts away SQL DDL operations so that engineers can just write C# to migrate their applications. Outside of Entity Framework, it is the most popular SQL framework in the .NET ecosystem.

I was wondering what it would look like to build a Processor/Generator for SpiceAI, given you now have a nuget package (congratulations).

I'm not really sure from the SDK examples if you even support anything beyond DML, as the example docs mention only .Query, even though the April 2026 release notes mention SPICE Cayenne supports CREATE TABLE statements. As an engineer, there are a lot of platforms like Space.AI, and my own observation is most of them advertise the DML part, but do a poor job explaining the DDL part. - Maybe there's a data governance angle as to why, as well as data accelerators angle, but most of the time it's hard onboarding journey to understand "How can this be supported in developer workflows" like dbt or FluentMigrator.

[phillipleblanc]

Thanks for reaching out, Spice has so far been focused (on the SQL side) on being a read-only federation & acceleration engine for remote data sources. As you saw, we are starting to add some more features that allow Spice to create tables in some configurations, but its still fairly limited (i.e. no ALTER TABLE is supported yet). So while I think it would be awesome to add support for this once we flesh out a better DDL story, at the moment I think it wouldn't be a great fit.