Clear ORM
Search…
Welcome to Clear
Introduction
Setup
Model
Defining your model
Associations
Lifecycle
Batchs operations
Transactions & Save Points
Locks
Querying
The collection object
Writing low-level SQL
Select Clause
Insert Clause
Delete Clause
Migrations
Manage migrations
Call migration script
Migration CLI
Additional and advanced features
JSONB
Symbol vs String
Enums
BCrypt
Full Text Search
Handling multi-connection
Other resources
API Documentation
Inline documentation
Github repository
Credits
Benchmark
Powered By
GitBook
Writing low-level SQL
Under the hood, Clear offers a performant SQL query builder for
SELECT
,
INSERT
and
DELETE
clauses:
Under the hood, the
1
Clear
::
SQL
.
select
.
from
(
"users"
).
execute
# SELECT * FROM users;
Copied!
Previous
Scopes
Next
Select Clause
Last modified
2yr ago
Copy link