Feature/Enhancement Request: boolean data type

[k98kurz]

Feature or Enhancement?

• (x) New feature
• ( ) Enhancement of existing feature

Description

bool column type annotations for subclasses of SqlModel should be acceptable. E.g.

class Example(SqlModel):
    columns = ('id', 'is_something', 'is_something_else')
    id: str
    is_something: bool
    is_something_else: bool|None

This entails the following:

• When data is retrieved for such columns, if it is not a boolean, it should be cast to bool.
• The migration system should support the boolean column datatype.
• The tool to make a migration from a model should parse the column type annotation properly and produce a correct migration.
• The CLI tool to generate a model class should accept --columns "is_something=bool,is_something_else=bool|None" and generate model class source with the correct type annotation.
• Unit tests for both subclasses of SqlModel and HashedModel
• Unit tests for joins
• Update e2e integration test
• Asyncql adaptation
• Asyncql unit tests
• Update asyncql e2e integration test

Additional context

Related to #8.

In sqlite3, true and false are understood when querying, but they are stored as 1 and 0, respectively, in the table. See https://www.sqlite.org/datatype3.html.

[k98kurz]

Done. Will be released shortly.