fmelink

I'm using CommandLineParser version 2.8.0. The usage example seems to use `default(MyEnum)` instead of the OptionAttribute Default or even `(new MyOptions()).Enum` as the default value. A workaround is to reorder...

MSSQLQuery insert datetime error

1

In MSSQLQuery, datetime objects get serialized with microsecond precision: ```python >>> pypika.MSSQLQuery.into('foo').columns('a').insert(datetime.now()) INSERT INTO "foo" ("a") VALUES ('2021-11-12T16:04:29.104453') ``` However, the database is not able to convert this string to...

The result from passing a list of lists to insert() is incorrect and differs from passing lists as positional arguments: ```python >>> pypika.MSSQLQuery.into('foo').columns(['a', 'b', 'c']).insert([(1,2,3), (4,5,6)]).get_sql() 'INSERT INTO "foo" ("a","b","c")...

The values "true" and "false" are not recognized and causes an "Invalid column name 'true/false'" error: ```python >>> pypika.MSSQLQuery.into('foo').columns('a').insert(False) INSERT INTO "foo" ("a") VALUES (false) ``` ``` Msg 207, Level...