Add support for MariaDB's "system-versioned tables" (temporal tables)

[lauxjpn]

The SQL Server provider recently added support for temporal tables.

While MySQL has not yet added support for temporal tables, MariaDB has in form of their system-versioned tables.

We should consider supporting those.

[woojunfeng]

any progress?

[lauxjpn]

@woojunfeng No, but since the community seems to want this, we will consider it for 7.0.

[kryptobi]

Do you think this will be released soon after the release of efcore 7?

[ThRintelen]

Yes, please, i need it!

[Hoopou]

@woojunfeng No, but since the community seems to want this, we will consider it for 7.0.

Any update on this?

[lauxjpn]

We haven't done any work on this yet. But as there seems to be general interest in that feature, we should consider it for 8.0.

[kryptobi]

We haven't done any work on this yet. But as there seems to be general interest in that feature, we should consider it for 8.0.

That would be a nice!

[kryptobi]

Any progress?

[okuhlen]

We haven't done any work on this yet. But as there seems to be general interest in that feature, we should consider it for 8.0.

Thank you!

[yhdezalvarez]

Any progress?

[lauxjpn]

Any progress?

Not yet, but it is probably going to be our top priority feature for 9.0 (or maybe the one right after ToJson() support).

[roji]

@lauxjpn it may be interesting to explore any common ground between MariaDB's feature and the SQL Server temporal tables feature that's already available - maybe let's keep in touch if/when you get around to working on this...

/cc @maumar

[lauxjpn]

@roji Absolutely! I opened the issue after watching Entity Framework Community Standup - SQL Server Temporal Tables and EF Core 6. The intention is to harvest as much as possible from the SQL Server code.

[roji]

OK! Hopefully there's some opportunity for even sharing some code (possibly after duplicating into your provider)? Maybe keep it in mind as you're working...

(also it may be time for that yearly beer ;))