prqlc 0.13.11

PRQL is a modern language for transforming data — a simple, powerful, pipelined SQL replacement.
Documentation 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90

use anyhow::Result;
use connector_arrow::api::{ResultReader, Statement};
use connector_arrow::arrow;
use connector_arrow::arrow::record_batch::RecordBatch;

fn read_to_batch<'a>(reader: impl ResultReader<'a>) -> Result<RecordBatch> {
    let batches = reader.into_iter().collect::<Result<Vec<_>, _>>()?;
    let schema = batches.first().unwrap().schema_ref();
    Ok(arrow::compute::concat_batches(schema, &batches)?)
}

pub(crate) trait DbProtocol: Send {
    fn query(&mut self, sql: &str) -> Result<RecordBatch>;
    fn execute(&mut self, sql: &str) -> Result<()>;
}

impl DbProtocol for connector_arrow::rusqlite::SQLiteConnection {
    fn query(&mut self, sql: &str) -> Result<RecordBatch> {
        let mut statement = connector_arrow::api::Connector::query(self, sql)?;
        let reader = statement.start([])?;
        read_to_batch(reader)
    }

    fn execute(&mut self, sql: &str) -> Result<()> {
        self.inner_mut().execute(sql, ())?;
        Ok(())
    }
}

impl DbProtocol for connector_arrow::duckdb::DuckDBConnection {
    fn query(&mut self, sql: &str) -> Result<RecordBatch> {
        let mut statement = connector_arrow::api::Connector::query(self, sql)?;
        let reader = statement.start([])?;
        read_to_batch(reader)
    }

    fn execute(&mut self, sql: &str) -> Result<()> {
        self.inner_mut().execute(sql, [])?;
        Ok(())
    }
}

#[cfg(feature = "test-dbs-external")]
pub(crate) mod external {
    use super::*;
    use futures::{AsyncRead, AsyncWrite};

    impl DbProtocol for connector_arrow::postgres::PostgresConnection {
        fn query(&mut self, sql: &str) -> Result<RecordBatch> {
            let mut statement = connector_arrow::api::Connector::query(self, sql)?;
            let reader = statement.start([])?;
            read_to_batch(reader)
        }

        fn execute(&mut self, sql: &str) -> Result<()> {
            self.inner_mut().execute(sql, &[])?;
            Ok(())
        }
    }

    impl DbProtocol for connector_arrow::mysql::MySQLConnection<::mysql::Conn> {
        fn query(&mut self, sql: &str) -> Result<RecordBatch> {
            let mut statement = connector_arrow::api::Connector::query(self, sql)?;
            let reader = statement.start([])?;
            read_to_batch(reader)
        }

        fn execute(&mut self, sql: &str) -> Result<()> {
            use mysql::prelude::Queryable;
            self.inner_mut().query_iter(sql)?;
            Ok(())
        }
    }

    impl<S: AsyncRead + AsyncWrite + Unpin + Send> DbProtocol
        for connector_arrow::tiberius::TiberiusConnection<S>
    {
        fn query(&mut self, sql: &str) -> Result<RecordBatch> {
            let mut statement = connector_arrow::api::Connector::query(self, sql)?;
            let reader = statement.start([])?;
            read_to_batch(reader)
        }

        fn execute(&mut self, sql: &str) -> Result<()> {
            let (rt, client) = self.inner_mut();
            rt.block_on(client.execute(sql, &[]))?;
            Ok(())
        }
    }
}