ODBC driver support for the SQL_ATTR_QUERY_TIMEOUT parameter
You can use database profiles to limit CPU time and/or logical reads per call or per session; while perhaps not as direct as a specific query timeout, they will allow you to accomplish your goal.