Since TVFs are UDFs (does not map to built-in methods), having to customize translation becomes less useful. (Also parameters would be in same order too). We will throw error in model validation if IDbFunction is IsQueryable, then configuring custom translation will throw exception.

Currently it assumes that a scalar SQL will come out. If we are planning to use same IDbFunction for queryable functions too then it needs rework or breaking change.