sed global Operate on every pattern match

echo $filename | sed 's|.sql||g'

#g global, Operate on every pattern match within each matched line of input, Unless the g (global) operator is appended to a substitute command, the substitution operates only on the first instance of a pattern match within each line.