That is weird too... On the column lookup side - it obviously works due to the discarded special characters.
However - your #234 does take the original column name (it wouldn't work otherwise). So this should be generating some double surrounding like:
```
insert into Test_DbFit(name, [[lucky Number]])
...
```
@mitchelldavis - can you check if this is the case? If yes, - perhaps MS SQL Server just works fine with double brackets too.