python 解决mysql where in 对列表(list,,array)问题

其实在很多实际开发中都会用到where xxx in (list)的查询语句进行数据查询，一般接口传参为了方便都会直接传递数组，那么该如何快捷的格式化sql语句呢

实例：

SELECT * FROM test where status='SUCESS' and operator_id in ('5122','5123');

前台传给过来的参数：

{
	"status": "SUCESS",
	"operator_id": ['5122','5123']
}

格式化：

filter_ret = ','.join(["'%s'" % item for item in operator_id])
sql = f"SELECT * FROM test where status='{status}' and operator_id in ({filter_ret})"