Could you please elaborate on this FK sniffing, and which tools are actually implementing that?
Ahhh, I know that Entity Framework would do this at one point, IDK if EF Core does or not.
Linq2Db does it via T4 Template generation, so you can play with it more if you want [0]
[0] - https://github.com/linq2db/linq2db/blob/64a0db9a9ed7787ff755...
It might make tooling 'easier', but since backwards compatibility has to be considered the actual value add is questionable IMO.
Most ORMs/MicroORMs will have tooling that sniffs out the DB Schema including foreign keys, and if you are using those bits (i.e. 'not hand written') most will do the right thing today. I suppose you could include some extra syntax for whatever DSL you're providing users....
IDK. Speaking as someone who is very comfortable in SQL, This feels more like syntactic sugar than anything else.