Simple dynamic query using sqlx.

// Example

pub async fn list_output_notes(
    pool: &PgPool,
    input: ListOutputNotesInput,
) -> Result<Vec<OutputNote>, sqlx::Error> {
    let date = input.page.after.and_then(|a| a.parse());

    let output_notes = sqlx::query_as!(
        OutputNote,
        r#"
    SELECT notes.id, notes.body, notes.output_id, notes.inserted_at, notes.updated_at
    FROM output_notes notes
    JOIN outputs o ON o.id = notes.output_id

    WHERE ($1::uuid IS NULL OR o.user_id = $1)    AND ($2::uuid IS NULL OR o.book_id = $2)    AND ($3::uuid IS NULL OR notes.output_id = $3)    AND ($4::timestamp IS NULL OR notes.inserted_at < $4)    AND notes.deleted_at IS NULL

    ORDER BY notes.inserted_at DESC
    LIMIT $5;
        "#,
        input.user_id,
        input.book_id,
        input.output_id,
        date,
        i64::from(input.page.first)
    )
    .fetch_all(pool)
    .await;

    output_notes
}