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?
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.