SqlPipeline
0.3.0
Apteco PS Modules - Wrapper for SimplySQL
Minimum PowerShell version
5.1
Installation Options
Owners
Copyright
(c) 2025 Apteco GmbH. All rights reserved.
Package Details
Author(s)
- florian.von.bracht@apteco.de
Tags
powershell Windows Linux Apteco
Functions
Add-RowsToSql Add-RowsToDuckDB Invoke-IncrementalLoad New-DuckDBConnection Initialize-SQLPipeline Close-DuckDBConnection Get-LastLoadTimeStamp Get-DuckDBData Invoke-DuckDBQuery Set-LoadMetadata Export-DuckDBToParquet Install-SqlPipeline
PSEditions
Dependencies
Release Notes
0.3.0 Added DuckDB.net support through Add-RowsToDuckDB and more
Added verbose output when importing module
Better usage of ImportDependency to recognize if local package dependencies are already loaded
Added local package installation for DuckDB.net (not needed for Add-RowsToSql, only for Add-RowsToDuckDB): Install-SqlPipeline
Added function to export DuckDB tables to Parquet: Export-DuckDBToParquet
0.2.1 Changing the way to look for existing tables
0.2.0 Support of Linux
0.1.5 Fixing case sensitive path for private and public functions
0.1.4 Prefixing SimplySql commands
Integration of ImportDependency module
0.1.3 Removing unnecessary Code
0.1.2 Throwing an exception now, when no transaction is used and the input is not valid
0.1.1 Fixed temporary module and script path loading
0.1.0 Improved the check for existing tables and columns. In this case the table will not be dropped the the SimplySQL update.
0.0.7 Bumped the copyright year to 2024
0.0.6 Fix of trimming when datatype is boolean or something else than String
0.0.5 Automatically trim values now, but there is a parameter to deactivate this behaviour
0.0.4 Adding support for Object[] and ArrayList to be converted into JSON, too
0.0.3 Fix for table existing check and prevent using more columns than needed (the leaded to overwriting columns that have default values like changedate)
0.0.2 Small fix for tables that are already existing, but empty
0.0.1 Initial release of SqlPipeline
FileList
- SqlPipeline.nuspec
- Private\SqlPipeline\Import-Package.ps1
- Private\SqlPipeline\Install-NuGetPackage.ps1
- Private\duckdb\ConvertTo-DuckDBType.ps1
- Private\duckdb\ConvertTo-DuckDBValue.ps1
- Private\duckdb\Get-DuckDBColumns.ps1
- Private\duckdb\Initialize-DuckDBTable.ps1
- Private\duckdb\Initialize-PipelineMetadata.ps1
- Private\duckdb\Invoke-BufferedWrite.ps1
- Private\duckdb\Invoke-DuckDBUpsert.ps1
- Private\duckdb\New-DuckDBConnection.ps1
- Private\duckdb\Repair-DuckDBRow.ps1
- Private\duckdb\Sync-DuckDBSchema.ps1
- Private\duckdb\Test-DuckDBTableExists.ps1
- Private\duckdb\Write-DuckDBAppender.ps1
- Public\SqlPipeline\Install-SqlPipeline.ps1
- Public\duckdb\Add-RowsToDuckDB.ps1
- Public\duckdb\Close-DuckDBConnection.ps1
- Public\duckdb\Export-DuckDBToParquet.ps1
- Public\duckdb\Get-DuckDBData.ps1
- Public\duckdb\Get-LastLoadTimestamp.ps1
- Public\duckdb\Initialize-SQLPipeline.ps1
- Public\duckdb\Invoke-DuckDBQuery.ps1
- Public\duckdb\Set-LoadMetadata.ps1
- Public\simplysql\Add-RowsToSql.ps1
- SqlPipeline.psd1
- SqlPipeline.psm1
- bin\dependencies.ps1
Version History
| Version | Downloads | Last updated |
|---|---|---|
| 0.3.0 (current version) | 4 | 3/25/2026 |
| 0.2.1 | 27 | 10/1/2025 |
| 0.2.0 | 7 | 9/30/2025 |
| 0.1.5 | 4 | 9/30/2025 |
| 0.1.4 | 7 | 9/30/2025 |
| 0.1.3 | 7 | 9/26/2025 |
| 0.1.2 | 5 | 9/26/2025 |
| 0.1.1 | 15 | 3/19/2025 |
| 0.1.0 | 14 | 1/27/2025 |
| 0.0.7 | 15 | 6/24/2024 |
| 0.0.6 | 28 | 11/14/2023 |
| 0.0.5 | 11 | 11/13/2023 |
| 0.0.4 | 8 | 11/11/2023 |
| 0.0.3 | 10 | 11/8/2023 |
| 0.0.2 | 10 | 11/8/2023 |
| 0.0.1 | 10 | 11/7/2023 |