A Survey of NL2SQL with Large Language Models: Where are we, and where are we going?