{
  lib,
  fetchPypi,
  buildPythonPackage,
  postgresql,
  unittestCheckHook,
}:

buildPythonPackage rec {
  pname = "pgsanity";
  version = "0.3.0";
  format = "setuptools";

  src = fetchPypi {
    inherit pname version;
    sha256 = "sha256-Po/DPQpk54w1gWOL9aArN6I8dmMb7uRYxuRMI6MIDKU=";
  };

  nativeCheckInputs = [
    unittestCheckHook
  ];

  unittestFlagsArray = [ "test" ];

  propagatedBuildInputs = [ postgresql ];

  # To find "ecpg"
  nativeBuildInputs = [ (lib.getDev postgresql) ];

  meta = {
    homepage = "https://github.com/markdrago/pgsanity";
    description = "Checks the syntax of Postgresql SQL files";
    mainProgram = "pgsanity";
    longDescription = ''
      PgSanity checks the syntax of Postgresql SQL files by
      taking a file that has a list of bare SQL in it,
      making that file look like a C file with embedded SQL,
      run it through ecpg and
      let ecpg report on the syntax errors of the SQL.
    '';
    license = lib.licenses.mit;
    maintainers = with lib.maintainers; [ nalbyuites ];
  };
}