SQL Server samples to a feature tensor

// Public placeholders only. Configure privately: aner secrets set demo-mssql-password
import aner.db;
import aner.db.mssql;
import aner.secrets;
import aner.data;
import aner.tensor;

let connection: DBConnection = mssql.connect(
    host: "sql.example.invalid", port: 1433, database: "example_science",
    user: "example_reader", password: secrets.stored("demo-mssql-password"),
    sslmode: "verify-full", timeout_seconds: 10);
// Run examples/fixtures/db_mock_mssql.sql once with your administration tool.
// Native ODBC binds ? parameters separately from the SQL text.
let result: DBResult = db.query(connection,
    "SELECT sample_id, feature_a, feature_b, feature_c, label FROM aner_demo.samples WHERE label = CAST(? AS int) ORDER BY sample_id",
    List("2"), max_rows: 1000, max_bytes: 1048576);
print(db.rows(result));
let table: DataTable = db.to_table(result, 1048576);
print(data.integer(table, 0, "label"));
let features = db.query(connection,
    "SELECT feature_a, feature_b, feature_c FROM aner_demo.samples ORDER BY sample_id",
    List(), max_rows: 1000, max_bytes: 1048576);
let matrix = data.to_tensor(db.to_table(features, 1048576), 1048576);
print(tensor.rows(matrix));
db.close(connection);