EF Core 8 Shadow Properties incur a 255 limit on columns

Question

We have an EF based WebApi, and the business logic includes the ability for end users to add user defined fields
To get that in EF, we engaged Shadow Properties, and that is working well
Unfortunately we found Shadow Properties incur a limit of 255 columns in a table
I could not locate documentation on the limit, but ChatGPT confirmed our findings

How can we increase the limit to something like 512?
Is it possible?
Otherwise, we will have to re architect the search and storage engines of our WebApi

Answer 1

as each shadow property requires a database column, does your chosen database server support more than 255 columns per table?