Question on the db query

  1. why there is no getdata in GUI mode, so I can only write the sql if I want to get the data?

  2. is there a limitation if I bulk insert data?

  3. after the action, do retool autocommit? how about if i want to have update and then insert and then commit?

  4. if I get code from sql, is there a limitation? how we handle the pagination? what if i want to handle large data, like daily filter the account that is expired and do the other action, is that ok in Retool? or retool has some other solution>