// Initialize ServiceSQL
const db = APPSQL.init({
  spreadsheetId: "YOUR_SPREADSHEET_ID"
});

// Define a Model
class User extends Model {}
User._table = "Users";
User._timestamps = true;
User._fillable = ["name", "email", "age"];
User._casts = { age: "int", verified: "bool" };
User.use(db);

// Create a user
const user = User.create({
  name: "John Doe",
  email: "[email protected]",
  age: 30
});

// Query users
const activeUsers = User.where("status", "active")
  .where("age", ">=", 18)
  .orderBy("name")
  .get();

// Work with relationships
class Post extends Model {}
Post._table = "Posts";
Post.author = function() {
  return this.belongsTo(User, "user_id");
};
Post.use(db);

// Eager load relationships
const posts = Post.with("author").get();
posts.each(post => {
  Logger.log(`${post.title} by ${post.author.name}`);
});