title: Rust type `bool` (as SQL type `BOOLEAN`) is not compatible with SQL type `TEXT`
body: <p>I am trying to fetch a column from an SQL table, the column type is boolean, but I get this error</p>
  <pre><code>Rust type `bool` (as SQL type `BOOLEAN`) is not compatible with SQL type `TEXT`
  </code></pre>
  <p>Here is my code</p>
  <pre class="lang-rust prettyprint-override"><code>pub struct Task {
      pub id: i32,
      pub title: String, 
      pub description: String,
      pub priority: Priority,
      pub completed: bool,
      pub due_date: String,
      pub project: Project,
      //reminders: Reminder[] | string,
      pub created_at: String,
      pub updated_at: String
  }
  
  
  impl Task {
  
  pub async fn all() -&gt; Vec&lt;Task&gt; {
          let db = load_db().await;
  
          let mut tasks: Vec&lt;Task&gt; = Vec::new();
          let mut query = sqlx::query(&quot;SELECT * FROM tasks&quot;);
          let mut rows = query.fetch(&amp;db);
          while let Some(row) = rows.try_next().await.unwrap() {
              let task = Task {
                  id: row.get::&lt;i32, &amp;str&gt;(&quot;id&quot;),
                  title: row.get::&lt;String, &amp;str&gt;(&quot;title&quot;),
                  description: row.get::&lt;String, &amp;str&gt;(&quot;description&quot;),
                  priority: Priority::High,
                  completed: row.get::&lt;bool, &amp;str&gt;(&quot;completed&quot;),
                  due_date: row.get(&quot;due_date&quot;),
                  project: Project { name: row.get(&quot;project&quot;) },
                  created_at: row.get(&quot;created_at&quot;),
                  updated_at: row.get(&quot;updated_at&quot;)
              };
              tasks.push(task);
          }
  
          tasks
      }
  }
  
  </code></pre>
  <p>Sqlite Table Structure.</p>
  <pre class="lang-sql prettyprint-override"><code>CREATE TABLE &quot;tasks&quot; (
      &quot;id&quot;    INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
      &quot;title&quot; VARCHAR(255) NOT NULL,
      &quot;description&quot;   TEXT DEFAULT NULL,
      &quot;priority&quot;  INTEGER NOT NULL DEFAULT 0,
      &quot;completed&quot; BOOLEAN DEFAULT FALSE,
      &quot;dueDate&quot;   VARCHAR(255) DEFAULT '0000 00:00:00Z00',
      &quot;project&quot;   INTEGER NOT NULL,
      &quot;createdAt&quot; VARCHAR(255) NOT NULL DEFAULT '0000 00:00:00Z00',
      &quot;updatedAt&quot; VARCHAR(255) NOT NULL DEFAULT '0000 00:00:00Z00',
      &quot;reminders&quot; TEXT DEFAULT '[]'
  )
  </code></pre>