Code RoomSQL injection via LIKE

MediumPrep Room Coding #2399

SQL injection via LIKE

Code reviewCode quality & reviewMid–Senior~18 min

An AI generated this search query handler. Review it.

What a strong answer looks like

Separate real bugs from style. Rank issues by severity, point at the root cause rather than the symptom, and suggest a concrete fix, specific and kind.

0:00 of about 18 min

Mark a line and say what kind of problem it is.0 findings

1def search(term):

2 rows = db.execute("SELECT * FROM products WHERE name LIKE ?", (f'%{term}%',))

3 return [r.to_dict() for r in rows]

Which questions mattered is sealed until you submit. Telling you now would just be handing over the edge cases.