Sync happens when the SQL data first loads in the data editor, or when a user first requests that data to load in their app.
Aside from that, you can trigger a sync by calling the Reload Query action.
If you add a full SQL table as a data source, it’s a two-way sync. If you add a a custom query, it’s read-only.
Hope that helps. 