But I guess that Emacs shows the matching closing bracket at the beginning of the line, which matches that single tuple. But you also need a closing bracket for the set of tuples like this:
insert ... ( (v1, v2, v3), (v4, v5, v6), (v7, v8, v9) <= this is the bracket pair that Emacs shows as matching. ); <= this is the missing bracket.
Except that isn't valid INSERT statement syntax. You are missing "values" and there is no enclosing parens:
INSERT INTO tbl (i) VALUES (1), (2), (3); --this is perfectly valid
That said seeing the first few rows, in addition to the last few, would help.