Spot2

Built on Doctrine's Database Abstraction Layer, Spot inherits robust database support and comprehensive type handling across MySQL, SQLite, and others, as shown in the field types list.

Uses plain PHP methods in entity classes for field and relation definitions, avoiding annotation magic and ensuring clarity, as emphasized in the philosophy section.

Provides automatic table creation and alteration based on entity field definitions via the migrate() method, simplifying schema management without external tools.

Allows execution of raw SQL queries that still load results into entity objects, offering an escape hatch for complex queries while maintaining ORM convenience.

Includes eager loading capabilities for relations with the with() method, helping to solve the N+1 query problem efficiently, as detailed in the relations section.