db taxonomies terms multi-site (multilanguage)

[vitalijalbu]

Bug description

Opening this issue from my discussion over there:
https://discord.com/channels/489818810157891584/1469428193206341702

So basically the problem is:

• taxonomies terms are stored inside the DB as single row (meanwhile eantries, for each site have their own rows).

That makes query very difficult and hard, and the translations are stored as JSON insite that row...
One more thing I've noticed that it’s not possible to have translated urls for every site... Cause now the url is generic (taxonomy-slug/term-slug)

Maybe it's a statamic cms issue? cause the terms URLS are not translated too (attaching rest api terms aswell)?!

How to reproduce

just having 2 sites (it - en) and create translated taxonomies terms

Logs

Environment

Statamic
Addons: 2
Sites: 2 (Italiano, English)
Stache Watcher: Disabled
Static Caching: half
Version: 5.73.3 PRO

Additional details

No response

[vitalijalbu]

That would be a breaking change as Ryan said

[ryanmitchell]

That makes query very difficult and hard

What does it make hard?

[vitalijalbu]

That makes query very difficult and hard

What does it make hard?

I mean that i need to extend the resource and create my URLs manually for every site...

[vitalijalbu]

I think it's more a related Statamic cms issue rather than eloquent-driver

[ryanmitchell]

Creating URLs is beyond the scope of this driver as (unless I'm mistaken) thats something that comes from Statamic core.

[vitalijalbu]

Creating URLs is beyond the scope of this driver as (unless I'm mistaken) thats something that comes from Statamic core.

Since we'll have localizable assets, would be like to have localizate taxonomies as well..
Inside statamic cp, would be fine to filter by site, add urls for every site and so on...
Nowdays (in v5) I've created a filter scope for that...