自动将SQL查询转换为python代码

Question

我正在尝试创建一个Python脚本，它可以使用正则表达式将SQL查询转换为Python脚本。有人能用Python来实现这一点吗

============SQL Query========
SELECT
   alert_id,
   Count(star_rating) as total_rating,
   Max(star_rating) AS best_rating,
   Min(star_rating) AS worst_rating 
FROM
   alerts 
WHERE
   verified_purchase = 'Y' 
   AND review_date BETWEEN '1995-07-22' AND '2015-08-31' 
   AND country IN 
   (
      'DE','US','UK','FR','JP' 
   )
GROUP BY
   alert_id 
ORDER BY
   total_rating asc,
   alert_id desc,
   best_rating 
LIMIT 10;

预期结果如下：

alerts.filter("verified_purchase = 'Y' AND review_date BETWEEN '1995-07-22' AND '2015-08-31' AND country IN ('DE', 'US', 'UK', 'FR', 'JP')")
.groupBy("alert_id")
.agg(count(col("star_rating")).alias('total_rating'),max(col("star_rating")).alias('best_rating'),min(col("star_rating")).alias('worst_rating')")
.select("alert_id","total_rating","best_rating","worst_rating")
.orderBy(col("total_rating").asc(),col("alert_id").desc(),col("best_rating").asc())
.limit(10)

Answer 1

我找到了一个为SQLAlchemy代码执行此操作的项目

https://github.com/pglass/sqlitis

FeatureMatrix似乎不完整，但它是开源的，因此为项目贡献可能比从头开始编写更好（而且它似乎是一个有趣且活跃的项目）

绝对不要使用正则表达式。我推荐经典，所以回答为什么不：RegEx match open tags except XHTML self-contained tags