import duckdb
import os
import polars as pl


db = duckdb.connect('/mnt/bulk/data/ynab_data.duckdb')

    # SELECT * FROM gold.transactions
relevant_data = db.sql('''
    SELECT
        transaction_date,
        sum(transaction_amount) as total
    FROM gold.transactions
    GROUP BY transaction_date
    ORDER BY transaction_date DESC
''')
print("Data after SQL query:")
print(relevant_data)