Use REGEXP with sqlite

regexp_sqlite.py

# This makes use of REGEXP within an sqlite3 query
```python
def regexp(expr, item):
    reg = re.compile(expr)
    return reg.search(item) is not None

def make_data():
    import sqlite3
    sql = """
        SELECT
            ot_risks.psm_shortname, 
            ot_risks.sys_desc,
            ot_risks.current_risk, 
            coalesce(ot_risks.dominant_conduit, 'Remote / OT DMZ'), 
            RiskRatings.RISK_WEIGHT
        FROM
            RiskRatings
            INNER JOIN
            ot_risks
            ON 
                RiskRatings.RISK_RATING = ot_risks.current_risk
        WHERE
            (
                (   ot_risks.current_risk REGEXP '(B|C)' 
                    AND coalesce(ot_risks.dominant_conduit, 'Internet') NOT LIKE '%Local%'
                    AND RiskRatings.RISK_WEIGHT > 21
                )
            OR ot_risks.psm_shortname REGEXP '(DCS|PCS|SIS|IPS|CCC|Power|PMS|PWR|POWER|ENMC|ICSS)'
            ) 
            AND	facility IN ('KGP')
        ORDER BY
            2 ASC, 
            1 DESC
    """
    DB_PATH = r'//path_to_file'
    conn = sqlite3.connect(DB_PATH)
    conn.create_function('REGEXP', 2, regexp)
 ```