feat: flush the delta buffer to duckdb in batched transaction #139

	# This workflow will build a golang project
	# For more information see: https://docs.github.com/en/actions/automating-builds-and-tests/building-and-testing-go

	name: Go

	on:
	push:
	branches: [ "main" ]
	pull_request:
	branches: [ "main" ]

	jobs:

	build:
	runs-on: ubuntu-latest
	steps:
	- uses: actions/checkout@v4

	- name: Set up Go
	uses: actions/setup-go@v5
	with:
	go-version: '1.22'

	- name: Set up Python
	uses: actions/setup-python@v5
	with:
	python-version: '3.10'

	- name: Install dependencies
	run: \|
	go get .

	pip3 install "sqlglot[rs]"

	curl -LJO https://github.com/duckdb/duckdb/releases/download/v1.1.0/duckdb_cli-linux-amd64.zip
	unzip duckdb_cli-linux-amd64.zip
	chmod +x duckdb
	sudo mv duckdb /usr/local/bin
	duckdb -c 'INSTALL json from core'
	duckdb -c 'SELECT extension_name, loaded, install_path FROM duckdb_extensions() where installed'

	- name: Build
	run: go build -v

	- name: Test packages
	run: go test -v -cover ./charset ./transpiler ./backend ./harness

	- name: Test Query Engine
	run: go test -v -cover --timeout 600s .

	- name: Test Binlog Replication
	run: go test -v -p 1 --timeout 360s ./binlogreplication

Provide feedback