Skip to main content

A module to analyze SQL query parameters and suggest corrections based on reference data.

Project description

SQL Rail Module

Version: 0.0.7 Date: May 13, 2025

A Python module to parse parameters within the WHERE clauses of an SQL query and suggest the closest valid or intended matches from predefined reference datasets.

Features

  • Parses SQL WHERE clauses to identify parameters.
  • Compares parameters against reference lists using multiple similarity/distance metrics.
  • Supports Levenshtein distance, Semantic Similarity (via sentence-transformers), and FuzzyWuzzy-like matching.
  • Extensible design for adding custom distance metrics.
  • Structured JSON output for analysis results.

Installation

pip install sql-rail

Project details


Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distribution

sql_rail-0.0.7.tar.gz (14.2 kB view details)

Uploaded Source

Built Distribution

If you're not sure about the file name format, learn more about wheel file names.

sql_rail-0.0.7-py3-none-any.whl (17.7 kB view details)

Uploaded Python 3

File details

Details for the file sql_rail-0.0.7.tar.gz.

File metadata

  • Download URL: sql_rail-0.0.7.tar.gz
  • Upload date:
  • Size: 14.2 kB
  • Tags: Source
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/6.1.0 CPython/3.11.11

File hashes

Hashes for sql_rail-0.0.7.tar.gz
Algorithm Hash digest
SHA256 b5e73f05c57edd584159366bc599870cbe8c0e653f0d34f8159c5082f4633a54
MD5 dedf0638cf12b80c2e9d44e4c6eea6cc
BLAKE2b-256 c3b1b3b1d5112e0d6c0d38adbb074eac735b40b7ca0aaadcf2f4e2fe4ad65525

See more details on using hashes here.

File details

Details for the file sql_rail-0.0.7-py3-none-any.whl.

File metadata

  • Download URL: sql_rail-0.0.7-py3-none-any.whl
  • Upload date:
  • Size: 17.7 kB
  • Tags: Python 3
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/6.1.0 CPython/3.11.11

File hashes

Hashes for sql_rail-0.0.7-py3-none-any.whl
Algorithm Hash digest
SHA256 cd75556c227be2daaeac9faf735033cd18026219494cd6fae973dbd8161524ad
MD5 eb8a31c48fb5bf41ae275acd1aa8cba3
BLAKE2b-256 2dd4ced603230c0cf703a3d22853b55acb371890c32ceff14e2f6e50f63cc4cf

See more details on using hashes here.

Supported by

AWS Cloud computing and Security Sponsor Datadog Monitoring Depot Continuous Integration Fastly CDN Google Download Analytics Pingdom Monitoring Sentry Error logging StatusPage Status page