modernize MiscQL