updated create table logic for using proper dbt render

[cody-scott]

Closing https://github.com/dbt-msft/dbt-sqlserver/issues/549 by updating to use proper relation instead of manually rendering.

Additionally adds test to validate behaviour.