I’d say the main contemporary competitors were Interbase (Firebird) and Jet. Jet couldn’t safely support a multithreaded program, it had to run in an “apartment” and communicate through a message loop. I didn’t play with Interbase at the time but it was preferred by Borland devs. But I enjoyed using SQL Anywhere and found it very full featured for such a small engine.