How you code your SQL inside your classes is your business, so from that perspective, dynamic sql is a non-issue with CSLA. I'm sure you will get several warnings about sql injection attacks.
As for dynamic properties, the only way I can think of doing it with an object would be to have a collection of properties. But that collection of properties could be done as a standard csla object and object list!
Copyright (c) Marimer LLC