SQLite Text type conversion to Option<DateTime<Utc>> reports an error ___^ the trait From<std::option::Option<std::string::String>> is not implemented for std::option::Option<chrono::DateTime<chrono::Utc>>

[cctyl]

I'm using the Rust frameworks Axum and SQLx to develop a web service.
Now I've encountered a problem. My entity class is as follows:

#[derive(Debug, Clone, Serialize, Deserialize, sqlx::FromRow,sqlx::Type)]
pub struct User{

    pub id:i64,
    pub name:String,
    pub email:String,
    pub password:String,
    pub role :UserRole,
    pub verified:bool,
    pub verification_token: Option<String>,
    pub token_expires_at: Option<DateTime<Utc>>,
    #[serde(rename = "createdAt")]
    pub created_at: Option<DateTime<Utc>>,
    #[serde(rename = "updatedAt")]
    pub updated_at: Option<DateTime<Utc>>,

}

My database table structure is:

CREATE TABLE users (
    id INTEGER PRIMARY KEY ,  
    name TEXT NOT NULL,
    email TEXT NOT NULL UNIQUE,
    verified INTEGER NOT NULL DEFAULT 0,  
    password TEXT NOT NULL,
    verification_token boolean,
    token_expires_at text,  
    role TEXT NOT NULL DEFAULT 'user' CHECK (role IN ('admin', 'user')),  
    created_at text   ,  
    updated_at text  
);

The query is:

 let user = sqlx::query_as!(
                User,
                r#"
                    select id, name, email, password, role as "role: UserRole", verified, verification_token, token_expires_at, created_at, updated_at
                    from users
                    where id = $1
                "#,
                user_id
            ).fetch_optional(  get_db()).await?;

My Cargo configuration is:

	chrono = { version = "0.4.26", features = ["serde"] } 
	serde = { version = "1.0.183", features = ["derive"] }
	serde_json = "1.0.104"
	sqlx = { version = "0.8.1", features = [
		"runtime-tokio",
		"tls-rustls-ring-webpki",
		"uuid",
		"sqlite",
		"chrono",
	] }

I'm focusing on the updated_at and created_at fields. Their corresponding types are: Option<DateTime> <===> TEXT.

When using them, I get the following error:

	error[E0277]: the trait bound `std::option::Option<chrono::DateTime<chrono::Utc>>: From<std::option::Option<std::string::String>>` is not satisfied
	  --> src\dao\user.rs:36:20
	   |
	36 |               user = sqlx::query_as!(
	   |  ____________________^
	37 | |                 User,
	38 | |                 r#"
	39 | |                     select id, name, email, password, role as "role: UserRole", verified, verification_token, token_expires_at, created_at, updated_at
	...  |
	43 | |                 user_id
	44 | |             ).fetch_optional(  get_db()).await?;
	   | |_____________^ the trait `From<std::option::Option<std::string::String>>` is not implemented for `std::option::Option<chrono::DateTime<chrono::Utc>>`
	   |
	   = help: the following other types implement trait `From<T>`:
				 `std::option::Option<&T>` implements `From<&std::option::Option<T>>`
				 `std::option::Option<&mut T>` implements `From<&mut std::option::Option<T>>`
				 `std::option::Option<&tracing_core::metadata::Metadata<'_>>` implements `From<&tracing_core::span::Current>`
				 `std::option::Option<&tracing_core::span::Id>` implements `From<&tracing::span::EnteredSpan>`
				 `std::option::Option<&tracing_core::span::Id>` implements `From<&tracing::span::Span>`
				 `std::option::Option<&tracing_core::span::Id>` implements `From<&tracing_core::span::Current>`
				 `std::option::Option<T>` implements `From<T>`
				 `std::option::Option<T>` implements `From<subtle::CtOption<T>>`
			   and 19 others
	   = note: required for `std::option::Option<std::string::String>` to implement `Into<std::option::Option<chrono::DateTime<chrono::Utc>>>`
	   = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query_as` (in Nightly builds, run with -Z macro-backtrace for more info)

However, according to the documentation at https://docs.rs/sqlx/latest/sqlx/sqlite/types/index.html, it states that chrono::DateTime can be converted to DATETIME (TEXT, INTEGER, REAL).

But in practice, I'm getting an error. What could be the reason for this?

[lihsai0]

For someone who is here. This is a simple but no where mention it (Please @ me if there is a document describe it).

The sqlx use the column name to comment type <col_name> AS "<col_name>: <Type>".

use chrono::{DateTime, Utc};
use sqlx::query_as;

let title = "some";
let article = query_as!(
    Article,
    r#"
        SELECT
            id,
            title,
            create_time AS "create_time: DateTime<Utc>"
        FROM article
        WHERE title LIKE "%?%"
    "#
    title
)
.fetch_one(db_pool)
.await?;