>CREATE SQL VIEW seems to always expand my macro. Thus, leaving me with the same statement in View Designer I started with.

But you shouldn't use View Designer anymore. View is ready and can be used in your program. You can also use DBSETPROP() to modify view properties.