A collection of PowerShell cmdlets to build SQL query strings, inteded for user with Invoke-SqlCmd (SQLServer).

Minimum PowerShell version


Installation Options

Copy and Paste the following command to install this package using PowerShellGet More Info

Install-Module -Name SQLQueryBuilder

You can deploy this package directly to Azure Automation. Note that deploying packages with dependencies will deploy all the dependencies to Azure Automation. Learn More

Manually download the .nupkg file to your system's default download location. Note that the file won't be unpacked, and won't include any dependencies. Learn More


Zachary F. Kerr


Copyright (c) 2020 Bentley Systems, Incorporated. All rights reserved.



Format-SQLSelectRowByKeyQuery Format-SQLInsertRowQuery Format-SQLUpdateRowByKeyQuery Format-SQLCreateTableQuery Format-SQLSelectTableInformationQuery Remove-SpecialCharactersFromString


This module has no dependencies.

Release Notes

Added Remove-SpecialCharactersFromString, and updated other cmdlets to clean strings before defining column names.

Version History

Version Downloads Last updated (current version) 54 6/22/2020 14 6/2/2020