In theory combining data access methods in a horses for courses concept is a great idea. It should allow data to be accessed in the manner most suitable for the task at hand. The one concern I have with it though is the increase in complexity it introduces.
If the approach taken by Hadapt helps to reduce that complexity as implied in this ZDNet Blog Post then it may be an approach that has appeal to business. If Microsoft are successful in bringing a similar concept to SS Management studio then business uptake will be rapid as it will provide that single pane of glass that IT departments (development and support) all crave.