Do I have to rebuild my queries after every update cycle?

Nope. Reports created using the SQL Report Builder are saved like those created in the traditional Report Builder. The update process for SQL charts is exactly the same - after your data is updated, the values in your charts will be recalculated and redisplayed.