Is there a way to dissolve features dynamically based on a field using a certain Shape.ST() function for a feature class in enterprise GDB?
If yes, what is this function?
Please clarify your question by specifying which RDBMS you are using (including a specific version) and which version of ArcGIS is available.
I am using ArcGIS Desktop & Server 10.3.1 with SQL Server 2014
Since you're using a Microsoft geometry type, the Microsoft documentation is the place to locate SQL functions.
The other side of this is the "for a feature class in enterprise GDB". I would urge you NOT to place such a function in a view -- the performance will likely be inadequate. You'll need to weigh your "dynamically" constraint against performance.